SSIS not inserting records in the sorted order -


i have written ssis pacakge sql server 2008 r2 using bids 2008 contains dataflow task insert 7 million records in destination table. problem facing records not inserting in sorted order in destination table. have set keep identity on , fast upload on oledb destination. how insert records in sorted order.

either sort them in destination or else use add index table in desired order.


Comments

Popular posts from this blog

python - Operations inside variables -

Generic Map Parameter java -

arrays - What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it? -