title: Unable to sort the records in Data Flow Task in SSIS
body: <p>I am trying to load around 7 million records from a flat file into a database. I need to sort these records for merging. My sort task within DFT(Data Flow Task) is able to read 7 million rows as input but outputs only 90k rows. Is there anny limit on the number of rows that can be sorted in SSIS? If yes, what are the possible alternatives.</p>