August 31, 2016 at 3:26 am
I have 60 rows ,SSIS processed 20 rows and 21 rows got error, now I want my package to run from taking 22 rows .
how to do in ssis
August 31, 2016 at 5:41 am
coool_sweet (8/31/2016)
I have 60 rows ,SSIS processed 20 rows and 21 rows got error, now I want my package to run from taking 22 rows .how to do in ssis
As 60 - 20 = 40, not 21, I'm not sure what you are trying to do here. Please elaborate.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 31, 2016 at 8:20 am
sorry type mistake, suppose i have 41 rows ,20 processed successfully and 21th got error.
now when next time my package run i want it to start fro 22 rows .
how to do it in ssis
August 31, 2016 at 8:33 am
coool_sweet (8/31/2016)
sorry type mistake, suppose i have 41 rows ,20 processed successfully and 21th got error.now when next time my package run i want it to start fro 22 rows .
how to do it in ssis
Not easy. Why not redirect all error rows to an error destination, rather than failing the package?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 31, 2016 at 8:34 am
The easiest way I can imagine doing this is by using the error output to store the rows that erred out and use that stored output as in put for the processing later.
Edit: Oops, looks like, once again, Phil and I were typing at the same time. 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply