April 8, 2002 at 11:11 am
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
April 8, 2002 at 5:22 pm
What is the exact error message?
April 9, 2002 at 2:30 am
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.
April 9, 2002 at 5:27 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy