Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
navkms
Starting Member
2 Posts |
 Posted - 2013-02-07 : 08:28:36
|
| Hi,I have a situation, I have 100 rows to be loaded to table, but problem is 90th record is bad record, where package fails!!! now when i restart package it should load only 10 records, should not start from beginning because when we have million records it'll be a time consuming!!!Thanks in Advance!!!RegardsSSIS learner |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-07 : 09:33:39
|
| you can make use of checkpoints in SSIS for restarting from failure point.For this set the options as below1. CheckpointFileName should point to filename2. CheckpointUsage should be set to Always3. SaveCheckpoints should be set to Truethen package will restart from failure point.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
navkms
Starting Member
2 Posts |
Posted - 2013-02-08 : 02:57:29
|
| @visakh16 : yes i know that, but if it fails inside dataflow task, it restarts from first step of dataflow task, wont start loading from which record it stopped. Is there any way by which i can load only 10 records at which package failed because of bad record |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-08 : 03:27:03
|
| In that case you need to add an onerror flow to capture error rows and process them separately so that it doesnt get failed in b/w------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Loading data to database table