December 13, 2012 at 4:33 am
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
December 13, 2012 at 6:11 am
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
there is as such no CheckPoint within dataflow task, but you can divide the flow of data in different task and go through with this..
but for 10000, let it be..it's not much ...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
December 13, 2012 at 6:15 am
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
December 13, 2012 at 6:17 am
Another option is to make sure your dataflow doesn't fail: add an error destination after the regular destination and set the destination to redirect error rows.
This doesn't help when your connection suddenly breaks or something like that.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply