How to Fill NTEXT Column from Script Component – SSIS

Posted on December 27, 2010 by Reza Rad

If you defined an output column in script component of type DT_NTEXT and you want to fill it with a string data, note that you can not use usual way like: Row.MyNTEXTColumn="something" this will not work for NTEXT, but you can use this way: Row.MyNTEXTColumn.AddBlobData(System.Text.Encoding.UTF8.GetBytes("something"))

Dynamic Row Delimiter and Column Delimiter in SSIS

Posted on December 10, 2010 by Reza Rad

There are times that you want to make Row Delimiter and Column Delimiter dynamic in Flat File source, and you want to change these values dynamically with package variables. usually you can use EXPRESSION properties for making things dynamic in SSIS, such as ConnectionString and bind it to a package variable. As you may know Read more about Dynamic Row Delimiter and Column Delimiter in SSIS[…]