Ssis Sort Task (Data Flow)

Robert Thorne
Robert Thorne
• • 2 min read

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...

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?

5

1 Answer

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

Must Read

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Robert Thorne

Robert Thorne

Automotive & Future Transportation Editor
Twitter Linkedin

Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.

Share this article
Twitter Facebook Pinterest