I stumbled on what appears to be a bug in the DTS Transform Data Task. It appears that it is truncating data. Just a little background:
I am running 32 bit SQL Server 2000 on 64 bit Server.
The source table is SQL Server 2000.
The Target table is SQL Server 2000.
When importing data into a field in the target (varchar(1)) I mistakenly mapped a field that was varchar(10).
No errors occured when the DTS package was run and nothing was reported in the log file.
The data in the varchar(10) field was truncated, turning the value "SWING" to "S"
I adjusted the DTS Package properties setting the USE TRANSACTION property to ON. Same results.
I unchecked the Use Fast Load option of the Transform Data Task. Same result.
The only similar reported bug that I can find:
The Copy SQL Server Objects task of DTS truncates fields of type text, ntext, and image if they exceed 8388602 bytes in length. No error messages are displayed by either DTS Designer or the DTS Import/Export Wizard. These both indicate the task completed successfully.
Any insight would be greatly appreciated!
Thanks