-
SQL Server7 DTS Transformation Error
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|