SSIS: Scope of OnError Event Handler

My SSIS package uses a connection string populated by a user defined variable.

I want to put an event handler on the connection manager to execute a task when there is an error with the connection string.

I have tried placing my task in the OnError Event Handler.

Here is the problem...........I have testing it with a bad connection string but the error seems to be generated before the OnError has a chance to capture the problem.

Can anybody help?
Mr_ShawAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Reza RadConnect With a Mentor Commented:
in Event handler tab,
set Executable with package (select  package name )
this means that on error will raise on every task in the package, and now you can find the error location exactly
0
 
Mr_ShawAuthor Commented:
I'll give it a go when I get into the office on monday.. thanks for the tip.
0
 
Reza RadCommented:
I think you got your answer in TechNET. am I right?
0
 
Mr_ShawAuthor Commented:
Thanks..
0
All Courses

From novice to tech pro — start learning today.