Statistics

Blog Administration

Powered by

Twitter

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. Also Trailer rows information needs to import to another destination.

So we have a situation to read both data rows delimited and trailer row which isn't delimited ( it's fixed length on each value )

This is one of the situations which Power of script component makes sense.