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 ««12

SSIS Custom Error Handling Expand / Collapse
Author
Message
Posted Thursday, April 22, 2010 1:28 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 9:02 AM
Points: 94, Visits: 573
I only tested it in 2008 -> I can't say that it doesn't work since I jumped over the 2005 versions.

Cheers
http://twitter.com/widba
http://widba.blogspot.com/
Post #908953
Posted Tuesday, May 04, 2010 11:55 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:46 PM
Points: 54, Visits: 239
I have come up with a query to dynamically crosstab your xml fields, I posted it on Jack's discussion, the link is below. Thanks

http://www.sqlservercentral.com/Forums/Topic487637-1254-11.aspx
Post #915547
Posted Wednesday, July 14, 2010 7:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 25, 2010 8:37 PM
Points: 1, Visits: 21
This is good stuff. Thanks a ton for sharing this.
Post #952312
Posted Tuesday, February 07, 2012 10:56 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 24, 2014 3:56 AM
Points: 13, Visits: 129
I have done Error Handling by getting the Error Column name from the lineageId and forming custom error message.


http://www.nkannan.com/2012/02/error-handling-in-ssis-dft.html



Thanks,
Nk
Post #1248355
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse