error when source and destination column numbers a

• Swapnilbajaj

  SSC Rookie

  Points: 32

  More actions

  April 8, 2002 at 11:11 am

  #157606

  Hi,

  when I transfer the data from sybase database to sql server database, I get an error when there is difference in number of columns. I am using DTS data pump object for transformation. When I do same by creating a package at sql server it works fine.

  There must be a property to take care of it

  Any pointers ..

  Thanks in advance

• Deuce

  SSCrazy

  Points: 2712

  More actions

  April 8, 2002 at 5:22 pm

  #426830

  What is the exact error message?

• Swapnilbajaj

  SSC Rookie

  Points: 32

  More actions

  April 9, 2002 at 2:30 am

  #426851

  Error Number: -2147213276

  Error Source: Microsoft Data Transformation Services (DTS) Data Pump

  Error Description: A DTSTransformCopy must specify no columns (signifying a sequential 1-to-1 mapping of all columns) or the same number of source and destination columns.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 9, 2002 at 5:27 am

  #426854

  quote:

  ---

  When I do same by creating a package at sql server it works fine.

  ---

  If you are creating the same package on the server then there must be some difference in your machines settings as opposed to the SQL Server itself with regards to the Sybased database. Are they exactly the same?

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)