Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Package Event Handlers Executables Disappear Expand / Collapse
Author
Message
Posted Thursday, November 06, 2008 6:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 04, 2009 1:35 AM
Points: 19, Visits: 64
I'm using BIDS 2005 (and SQL Server 2005). When I open a project's package, the executables on the Event Handlers tab do not show up, but they work in the background.

The event handler "OnError" is bold but the ExecuteSQL and Script tasks I put there are hidden so I cannot modify them.

Any help will be appreciated.
Post #598061
Posted Thursday, June 07, 2012 1:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 07, 2012 5:10 AM
Points: 4, Visits: 1
Hi,

Before you move to Event handlers tab. Make sure no task is selected, by clicking in the free space of the package and then click on event handlers tab.
Post #1312322
Posted Thursday, June 07, 2012 3:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:31 PM
Points: 12,239, Visits: 9,212
You can browse to the desired event handler using the Package Explorer tab.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1312373
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse