There are many situations which you can use power of scripting in SSIS data flow. Today I encounter a situation here , there is source flat file here with header and trailer records which have different structure from data rows. Data rows delimited by vertical line ( | ) , but header and trailer not. Read more about Script Component as Source – SSIS[…]
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"))
Suppose you have a flat file which is not delimited or fixed width or Ragged right. the structure of data is not well formed for Flat File Connection manager to read, This is an example of data file: date : 04/14/2010customer name : John doeaddress : 2014 apple st. Chicago, IT 30000sale order Read more about How to use Script Component as Asynchronous Transformation[…]