Solved

SSIS: Scope of OnError Event Handler

Posted on 2010-09-04
4
769 Views
Last Modified: 2013-11-10
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
Comment
Question by:Mr_Shaw
  • 2
  • 2
4 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 500 total points
ID: 33605596
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
 

Author Comment

by:Mr_Shaw
ID: 33606068
I'll give it a go when I get into the office on monday.. thanks for the tip.
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 33614815
I think you got your answer in TechNET. am I right?
0
 

Author Closing Comment

by:Mr_Shaw
ID: 33615933
Thanks..
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now