Need Help in SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Need Help in SSIS

Need Help in SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

sagar0838

Posted Thursday, December 13, 2012 4:33 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 12:53 AM
Points: 18, Visits: 93

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

Post #1396115

demonfox

Posted Thursday, December 13, 2012 6:11 AM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074, Visits: 1,076

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

Post #1396150

Koen Verbeeck

Posted Thursday, December 13, 2012 6:15 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

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 Smile

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1396151

Koen Verbeeck

Posted Thursday, December 13, 2012 6:17 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

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.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1396152

« Prev Topic | Next Topic »

Permissions