title: Maintaining correct order when transferring records with Data Flow Tasks into a DB table
body: <p>I have the following problem with a Sequence Container in an SSIS package in SQL Server 2008. In the container I have around 50 data flow tasks, which all transfer data from text files to one table in the SQL database. Every text file has the same construction so the data flow is identical. I have set it up for each transfer to happen one after the other. However, after running the transfer now, the top line is line 1774 from the 39th table to be transferred! How can I make it keep the records in the destination table in exactly the same order that they were transferred?</p>