sagar0838 (12/13/2012)
while loading 10000 records if the SSIS package got failed at 9000th record,how do we reload from 9001 record ,can anyone please help me out on this
Normally if the dataflow fails the inserts should be rolled back, but this depends on your settings of the OLE DB destination. Since 10000 rows should fit into one buffer, it will rollback by failure when using default settings.
So you have to start over, like it or not 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP