Fix DT_TEXT and DT_NTEXT Read only behavior in Script Component

Make sure the column is set to Read/Write. The BLOB data type has a different interface in script component pipeline.

Use AddBlobData() method in script component for DT_TEXT or DT_NTEXT), for example;

using System.Text
..
Output0Buffer.AddRow();          Output0Buffer.Description.AddBlobData(Encoding.Unicode.GetBytes(row[0].ToString()));

FavoriteLoadingAdd to favorites
Spread the love

Author: Shahzad Khan

Software developer / Architect