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!!!
Unfortunately the data flow cannot be restarted in the middle of a load.
There are a few options:
* make sure there are no bad rows before you attempt the insert. This means you'll have to introduce some data quality checks
* make sure your load is fast enough, so that it is no problem if the entire load has to be restarted
* change the batch size so the 90 rows are committed before the failure (this will slow the load down unfortunately). When you restart the process, check for the latest row that has been inserted and modify the where clause in the source, so that you only
select data you need.
* implement a lookup that checks if incoming rows are updates or inserts. That way you'll only insert rows that were not inserted yet.
MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
Marked as answer byEileen ZhaoThursday, February 14, 2013 8:28 AM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.