Hello,

I am doing a Datapump from my Source Database (A) to Destination Database
(B).

I connect to my source DB A using OLEDB. Do a Select Query to read all the
data and pump it row by row to the Destination Database to which I connect
using a destination Script Component.

One of my source column is of type "ntext"
Question: In my destination Script Component I override the PreExecute
method to prepare my Insert Statement.
And then on my ProcessInputRow method I copy my source
column to the destination columns and do a cmd.ExecuteNonQuery( ).

The problem that I am having is when it comes to the
following statement:
cmd.Parameters.Item("@Description").Value = Row.Description

I get an error saying that a BlobColumn cannot be converted
to a string type.

I can see that the Row.Description is a BlobColumn but can't figure out how
to obtain my resulting column value from it?

Please help.

--
Regards,
Sami

[Remove Numbers from e-mail address to use it]