I am new to SSIS, and looking for help.
I do not know if it is possible, but I like to try using the "Script Component" to change a input like this:
to and output like this:
Depending of the input value, 1 or more Rows are pushed out the Output, Like the value 1234 -> result in 1 Row in the output, where the value 1235 -> result in 3 rows in the output.
Is this possible to do in a Script Component?? If it is how do you program such behavior?
Do some good sources to learn SSIS exist out there?? I think it is not easy to find information.
View Complete Post