Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need Help in SSIS Expand / Collapse
Author
Message
Posted Thursday, December 13, 2012 4:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 21, 2013 5:56 AM
Points: 18, Visits: 99

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
Posted Thursday, December 13, 2012 6:11 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 9:03 PM
Points: 1,128, Visits: 1,161
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
Post #1396150
Posted Thursday, December 13, 2012 6:15 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:09 AM
Points: 12,242, Visits: 9,214
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




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
Posted Thursday, December 13, 2012 6:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:09 AM
Points: 12,242, Visits: 9,214
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 »

Add to briefcase

Permissions Expand / Collapse