Try to transfer the data to a non-existing table in SQL Server and see how the DTS package creates this column in the new table (which datatype).
If the data is then transferred properly, use this “temporary” table to hold the data and insert the data to the real table using an insert statement, in SQL Server , after the transfer (converting that column if required).
Please let me know how it went.
Thanks,
Michelle.
Discuss This Question: 1  Reply