Thanks for reply Jack.

I guess then I need to wait until the company converts to VS 2008...

Is there like an Express version of VS 2008 free of charge?

Jack,

I tried to open your "JDC.SSIS.Logging.sln"

in my Visual Studio 2005

and got this error:

"The selected file is a solution file but was created by a newer version of this application and...

Here is what I found on MSDN about "&" character...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1500001&SiteID=1

With XML the ampersand needs to be escaped as & a m p ; otherwise your data is not...

Hi Jack,

So how about that little bug?

My output column has

"MAIN & RUPERT, WINNIPEG, MAN."

value and insert into [load_errors] table fails with this error:

Error: 0xC0202009 at DFT_branch, OLE DB Destination [5537]:...

This worked...

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class ScriptMain

Inherits UserComponent

Public Overrides Sub PostExecute()

Variables.vGlobalErrorCount...

Hi Jack,

I tried to increment vGlobalErrorCount in ErrorDetails Script step

but got an error:

The collection of variables locked for read and write access is not available outside of...

Jack,

My boss doesn't want me to build any SSIS packages based on

custom components. I personally would definitely give it a try but

he's the boss...

So everything looks good now except...

Hi Jack,

I didn't invent any new Error Script components.

I used the same your Script.

And the results are good. I get all the errors logged.

load_error_idpackage_run_dateerror_desc

--------------------------------------------------

12008-10-21 13:59:37.000The data value violates integrity constraints.

22008-10-21...

Hi Jack,

Correct me if I'm wrong.

So I should...

Hi Jack,

Data conversion...

Jack,

I hope I found a way around.

The fact OLE DB Constraint Violation error sort of

hijacked the buffer pushed me to this idea.

Instead of connecting "DCNV_1" and OLE DB Destination

I...

Jack,

I've attached my BRANCH2.DTSX file

together with a screen shot.

"DCNV_1" Data Conversion task is where rows being redirected on error.

As you can see 3 records arrive at "DCNV_1" step.

1 record is...

Hi Jack,

I have problems with using your Error Script.

It's all working fine when I have:

1. Records Row1,Row2,Row3 all fail conversion (all is logged nicely into load_errors)

2. Records Row1,Row2 fail conversion...

Jack,

Is it possible to have Error Output columns at OLE DB Destination component?

If after all Conversions and manipulations you finally get an INSERT failure

can you capture that failure in [error_load]...

I figured it out how to read XML column.

A question.

So it looks like the whole purpose of this Error Script component

is to get ErrorDesc value. Right?

In my case it was...