Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 808
  • Last Modified:

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?
0
Mr_Shaw
Asked:
Mr_Shaw
  • 2
  • 2
1 Solution
 
Reza RadCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now