I have 10 package in SQL server integration service. When I was trying to execute them out of them 5 are executed correctly, then 6, 7 are giving error and 8, 9, 10 are executed correctly... So how we can handle it?
Asked
Active
Viewed 12 times
0
-
provide integration snippet or error log to find where the error is. – Ajith Pandian Dec 01 '16 at 06:07
1 Answers
0
You could write an OnError Event Handler for the package that captures all the error values and writes them to a db error table or flat file.

Mark Hedley
- 199
- 2
- 8