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 Tuesday, March 17, 2009 12:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 6:07 AM
Points: 94, Visits: 576
Comments posted to this topic are about the item SSIS Custom Error Handling

Cheers
http://twitter.com/widba
http://widba.blogspot.com/
Post #677208
Posted Wednesday, March 18, 2009 7:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, May 16, 2014 2:53 PM
Points: 373, Visits: 252
I would like to give this a try. However, I've never added a custom component and I'm struggling with registering it. I'm using Visual Studio 2005. I'm not finding a gacutil.exe that I obviously need so I can register it. Any help is appreciated. Thanks!
Post #678456
Posted Wednesday, March 18, 2009 7:48 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 6:07 AM
Points: 94, Visits: 576
The article references using 2008 - follow the link to Jack's original article, he has the components setup for 2005.



Cheers
http://twitter.com/widba
http://widba.blogspot.com/
Post #678466
Posted Sunday, May 3, 2009 11:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 17, 2012 1:51 PM
Points: 6, Visits: 14
First, I really want to thank you for this component. It really made my life lots of easier.
But somehow, I SSIS_LOG_ERROR table, all the ErrorDesc contains "No status is available. ". When I know the error id caused by FK constrain.

Do I miss anything?

Any help is greatly appreciated.



Post #709068
Posted Wednesday, February 24, 2010 8:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 11, 2010 9:13 PM
Points: 2, Visits: 4
It seems like anytime there is an error with the entire row, such as a PK constraint, you get that same message. I have tried a couple of other scripts and they return the same information.

I have a question about the field name column. Within my table I get '<fields />' with a hyperlink to an xml file. The only thing in this file is the same <fields /> text. Any ideas why I wouldn't be getting the field name or is there a trick to getting it?

Thanks in advance.
Post #871966
Posted Wednesday, February 24, 2010 9:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 11, 2010 9:13 PM
Points: 2, Visits: 4
I figured it out. I forgot to check the individual columns that I wanted to see in the buffer.
Post #872012
Posted Wednesday, February 24, 2010 10:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 6:07 AM
Points: 94, Visits: 576
sorry - had the message 1/2 typed out and got pulled away. you need to select the columns you want persisted into the XML- as you said

I need to open the code up and see why the error messages are generic. I focused more on the data gathering than the actual error, but that was the narrow focus that I was going after.


Cheers
http://twitter.com/widba
http://widba.blogspot.com/
Post #872040
Posted Thursday, April 22, 2010 12:51 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 3:46 PM
Points: 54, Visits: 239
I have registered the component successfully to add to the BIDS Toolbox, however, I do not see the custom component listed. I am using Visual Studio 2005 with SQL Server 2005.



C:\Documents and Settings\1\My Documents\SSISLogging\bin>reg.cmd

C:\Documents and Settings\1\My Documents\SSISLogging\bin>copy "C:\Documents and
Settings\1\My Documents\SSISLogging\bin\SSIS.Logging.dll" "C:\Program Files\Micr
osoft SQL Server\90\DTS\PipelineComponents\"
1 file(s) copied.

C:\Documents and Settings\1\My Documents\SSISLogging\bin>"C:\Program Files\Micro
soft Visual Studio 8\SDK\v2.0\Bin\sn.exe" -Vr "C:\Program Files\Microsoft SQL Se
rver\90\DTS\PipelineComponents\SSIS.Logging.dll"

Microsoft (R) .NET Framework Strong Name Utility Version 2.0.50727.42
Copyright (c) Microsoft Corporation. All rights reserved.

Verification entry added for assembly 'SSIS.Logging,55BF2292469930A5'

C:\Documents and Settings\1\My Documents\SSISLogging\bin>"C:\Program Files\Micro
soft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe" /if "C:\Program Files\Microsoft S
QL Server\90\DTS\PipelineComponents\SSIS.Logging.dll"
Microsoft (R) .NET Global Assembly Cache Utility. Version 2.0.50727.42
Copyright (c) Microsoft Corporation. All rights reserved.

Assembly successfully added to the cache
Post #908923
Posted Thursday, April 22, 2010 12:57 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 6:07 AM
Points: 94, Visits: 576
Jack Corbett's article (mine is a derivative of his) talks about SQL/VS 2005 implementation. This article refers to a 2008 version - sorry.

Cheers
http://twitter.com/widba
http://widba.blogspot.com/
Post #908930
Posted Thursday, April 22, 2010 1:01 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 3:46 PM
Points: 54, Visits: 239
Yes, I was able to successfuly implement Jack's version, however, I really wanted to add the script to the toolbox, for ease of developement.

So, this version will only work in 2008?
Post #908934
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse