0

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?

George Kagan
  • 5,913
  • 8
  • 46
  • 50

1 Answers1

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