CODEWITHSUNDEEP
sortingssisdataflowtask
Rachel
Rachel

Reputation: 218

SSIS Sort task (data flow)

I have a package where I am sorting by Aged Months column, I am not doing any other thing to filter the data and I am not removing duplicates, but once the data flow passes the Sort task the output rows are much less than the input. (1.218.206 rows in - only 53,344 out) any clue what's happening here?

enter image description here

Upvotes: 0

Views: 737

Answers (1)

Rachel
Rachel

Reputation: 218

I just solved it, I removed a derived column at the end of the package with some calculations and now all data get loaded into my destination. it doesn't make any sense since the derived column is way below the sorting task but for some reason that worked.

Thank you @DrHouseofSQL

Upvotes: 1

Related Questions