Nov 24, 2010

SSIS - Script Component, Split single row to multiple rows - Sudeep's Domain

Scenario:
We have a text file and we need to read each row and the output would have multiple rows per row in the input file.

Input File:

"201001","1;3"
"201002","1;2;3;4"

Expected output:

2010-01-01 01
2010-01-03 03
2010-02-01 01
2010-02-02 02
2010-02-03 03
2010-02-04 04