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.
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?
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply