Will ssis script component output be sorted?

Question

I am adding rows in sequence in a script component. The sequence is such that I am parsing values from an input string then adding them to the output. This way all values from a particular input string are added before those from the next input string ( or so I assume).

Is this assumption incorrect?

I ask because I need to use the pivot transform (needs data sorted) after the script component and for performance reasons I would rather not add a sort between them.

So when I pivot on the original input string's identifier, will my pivot results be correct?

Answer 1

I needed a similar solution. Short answer is yes but this may depend on how you write your script task. Using the Input0Buffer buffer and calling .NextRow and then after what ever logic / processing you do, send the row to the one of your outputbuffers using AddRow. The operation becomes a synchronous row by row operation.