I have a DTS package in SQL Server 2000.
I am migrating a table with a text column from SQL to another database platform (Sybase ASE 12.5.3) using a Transform Data Task.
The text data type is not supported in the Transform Data Task, so I am breaking up the data using the substring function (i.e. substring(myTextColumn, 1, 1500) in the query for Source and sending to a char(1500) destination, thus eliminating the issue with text. I then piece back together at the destination using an Execute SQL Task to the destination table with the receiving text column.
The problem occurs when there are spaces at the cut and paste point (i.e. at position 1500). The transformation is trimming the trailing spaces. How can I ensure that all 1500 chars are transformed to the destination, regardless of whether there are spaces at the end?
Thanks,
Dawn
Start Free Trial
