The objective is to store dBase IV memo field data in a column of data type "image".
In the Data Transform Task VB
script, a statement of the form DTSDestination("image-col") = DTSSource("memo-col") fails with a "Run Time Error" (no more specific error info is provided). If the destination column if of data type "text", this statement works fine.
A statement of the form x = DTSSource("memo-col") works. Variable x has as a character string value the contents of the memo field. A subsequent statement of the form DTSDestination("image-col") = x fails with the same "Run Time Error".
How do I cause the character string value from the dBase IV memo field to be assigned as the value of the destination image column?
Note: The reason for using a column of data type "image" is that, after migrating the legacy dBase 4 memo data, any new data stored in the column will be in the form of a Microsoft Word document.
I'm using SQL Server 2000 with SP3.
Thanks in advance for any assistance!