SQLServerLIfer,

Thank you so much for your input.

Looks like a comprehensive solution.

I'll read about this REPLICATE thing more.

I'm not familiar with it.

Sorry.

My fault.

The column is INT.

Not CHAR(2)

Hi Jack,

Of course SQL code will solve this very easily.

But remember? My boss doesn't want to see any "Execute SQL" Tasks

in SSIS. Unfortunately....

Unless it's really has a value and is...

sqlizer,

Your code does not give the right results if the column is INTEGER.

Lynn's code works perfectly.

Thank you Lynn.

So

only adds leading 0 in case LEN is less than 2?

I'm just trying to understand the mechanism...

I tried what you suggested.

It worked.

But the results I saw are not the ones I expected.

But that's another story.

When I display ErrorDescription in a Script

I see one error descriptions and...

You mean building the statement string as a variable

and then select Source as a variable?

It makes me crazy...

This works:

and this fails:

I checked in a Script. ErrorDescription is populated.

Public Class ScriptMain

Public...

I try to simplify the situation to isolate the problem.

Now I just write to error_desc VARCHAR(255) column:

but got an error again!

Error: 0xC002F210 at...

Peter,

I copied your code

and pasted it to Expression window.

Got error again:

Error: 0xC002F210 at SQL_LogError, Execute SQL Task: Executing the query "INSERT stg.Errors(error_code)

VALUES (

'' + @[System::ErrorCode] + ''

)

" failed with...

Thank you for your feedback Michael.

This is the direction I am moving in.

I created a base package (template) with all connections and even

Data Flow steps. I prefer to modify Derived...

Jack,

Will I be able to build your component using that Express C# or VB.NET VS2008? If I compile it using VS2008 Express will I be able to use that...

It looks like inside Data Flow there is no way

to make a decision whether to proceed or to stop

based on the RowCount value returned from Error Output.

In my case...

I know there is a Row Count component

but how do you implement conditional flow?

I can not have two paths with an Expression like:

@[User::vGlobalErrorCount] != 0

It only works in Control Flow.

This Error Script will translate Error Code into Error Description...

http://www.sqlservercentral.com/articles/Integration+Services/62662/[/url]