SQL Server Blogs

Voices from the UK SQL Server Community

msi Enhanced Error Component - SQL 2008 edition - beta

Downloads: 318 File Size: 734kB
Posted By: simonsabin Views: 5,549
Date Added: Wed, Jun 17 2009

This custom component is used to to add the column name an error occurred in to the data flow in Intergration Services.

This is not compatible with some older versions of the SQL 2005 version. If you have a component that takes 2 inputs then to use this new component you will need to delete the old one and drag the new one from the toolbox.

Installing the component,

  1. Un Install any previous versions
  2. Run the setup
  3. Open VS and load or create a SSIS package
  4. Open the toolbox, right click and select "Choose items..."
  5. Select the SSIS Data Flow components tab
  6. Check the check box next to the enhanced error component

This should now result in the Enhanced Error Component appearing in the toolbox.

To use the component it is simple,

  1. Open your SSIS package
  2. Drag the Enhanced error component onto the data flow.
  3. Attach an error output to it
  4. Double click on the component
  5. Select whether you want to have the error column and/or the error description added to the flow.
  6. Connect the output of the component to a destination or another component
  7. Run your package.
  8. If you add or change any columns you have to double click on the component again. This lets the component read the meta data of the package.

This has not had extensive testing with destination components. It is best for use when errors are raised against a single column.

Feel free to contact me using the links above with any feedback/bugs/suggestions.

I hope you find it useful please Donate through Paypal

Filed under:



scott_babineaux said:

can't load 08 beta version of component into VS05.
Mon, Jun 22 2009 7:53 PM

srangasw said:

fantastic - works for me too on vs2008 - can i get the source code, please...
Fri, Aug 21 2009 6:46 PM

gdk said:

works great on vs2008 - could you provide the source code, please...
Tue, Sep 29 2009 8:03 PM

Ray Sid said:

Works great, is it possible to get the source code? It would be great!
Wed, Jan 27 2010 7:14 PM

kalyanG said:

I am getting below error when I am try to click on component.please help me on this issue.Object of type 'Onarc.SQLServer.SSIS.UIInterface,Onarc.SQLServer.SSIS.Components.ErrorFlowComponentUI, Version=, Culture=neutral, PublicKeyToken=314cbe55a41d0c70' does not implement the expected component editor interface. Verify that the component editor is installed properly.
Tue, Mar 23 2010 8:40 AM

Majiktom said:

Awesome, the Error Description is simple: Row.ErrorDescription = this.ComponentMetaData.GetErrorDescription(Row.ErrorCode); But The COlumn Name was killing me. Great little Object, Source code dude, I'll give ya $20!
Sun, Oct 2 2011 4:36 AM

Majiktom said:

Yeah really need your source code. Your ErrorDescription is inserting an extra cariage return at the end of the error description and it's causing extra line feeds in my flatfiles.
Mon, Oct 3 2011 6:19 PM

HainesInformatics said:

Hi i think this could be a lifesaver for me but i get the error "TITLE: Microsoft Visual Studio ------------------------------ Could not load type: Onarc.SQLServer.SSIS.UIInterface,Onarc.SQLServer.SSIS.Components.ErrorFlowComponentUI, Version=, Culture=neutral, PublicKeyToken=314cbe55a41d0c70. Verify that the component editor is installed properly. ------------------------------ ADDITIONAL INFORMATION: Could not load file or assembly 'Microsoft.SqlServer.Dts.Design, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ " Please Help.
Mon, Mar 19 2012 12:57 PM
Powered by Community Server (Commercial Edition), by Telligent Systems