When I run a DTS package that transfers data from an Access 97 database to SQL Server7 (with SP1 installed) I get a problem with Access Memo fields. If the package does a straight transfer of data then I get no problems. However, if I use a transformation script (activeX script) in the package it truncates the last character of the memo field when it transfers the data to SQL server. The transformation script does nothing more than copy the source fields to the destination fields. I have searched the Microsoft sites for the error but have found nothing.

Any help would be much appreciated.

Richard.