Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 818
  • 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 RadConsultant, TrainerCommented:
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 RadConsultant, TrainerCommented:
I think you got your answer in TechNET. am I right?
0
 
Mr_ShawAuthor Commented:
Thanks..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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