error when source and destination column numbers a

  • 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

  • What is the exact error message?

  • 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.

  • 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)

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply