HomeForum
Welcome, Guest

Sybase Transform Error: Insert failed: 42000
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Sybase Transform Error: Insert failed: 42000

Sybase Transform Error: Insert failed: 42000 2 years, 10 months ago #685

  • Cox
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Is there any way to see what the SQL that the \"Writer\" is using for an insert record? I don't see anything obviously wrong with the Transform I'm trying to do but...

I keep getting the following:

Writer: {ODBC_Sybase},[Table=table_name]Insert failed: 42000[Sybase[ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near ','.

Using:
Advanced ETL Processor Professional Eval version 3.3.0.21
Installed on Windows Vista-64 bit OS.

Re:Sybase Transform Error: Insert failed: 42000 2 years, 9 months ago #686

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Latest version is 3.3.2.O

Can you try it please and let us know the outcome

Peter

Re:Sybase Transform Error: Insert failed: 42000 2 years, 9 months ago #687

  • Cox
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
No change. Same error.

Re:Sybase Transform Error: Insert failed: 42000 2 years, 9 months ago #688

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Please email us your repository log files and some screenshots so we can see writer mapping
mike
  • Page:
  • 1
Time to create page: 0.16 seconds

Testimonials

"Using Visual Importer ETL was a lot easier than we expected it to be, and had a lot more functionality than our other software."

Daniel Boel,
Information Technology Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top