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

Error handling Expand / Collapse
Author
Message
Posted Thursday, November 8, 2012 2:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:31 AM
Points: 17, Visits: 46
Hi all.

We are handling the errors at the package level and inside the data flow task we have many lookups and if there is an error in the lookup or any transformation how do i fetch in which lookup transformation the error has occured.

We are triggering the error mail in which we need to get the info in which lookup we got error pls helo me in this.


Thanks in Advance
Post #1382337
Posted Friday, November 9, 2012 12:27 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:08 AM
Points: 13,616, Visits: 10,501
I'm not sure this is possible.
The name of the erroring component is not made available in the event handlers. Only the name of the dataflow is made available (System::TaskName).




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 #1382856
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse