I don't have too much XML experience.

How do I query [load_errors].error_details

so that it is more readible?

I mean reading a long XML string is not fun.

Thank you Jack.

Script was OK.

My fault. I didn't understand it well.

Jack, my output column has

"MAIN & RUPERT, WINNIPEG, MAN."

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

Error: 0xC0202009...

Jack,

In your article you instruct to create the following 5 output columns:

ErrorSource

ErrorDetails

ErrorDesc

ErrorTask

PackageTime

But in your Script you refer to ErrorCode column:

which is not available.

What it should be?

Jack,

I also want to understand why in my pipeline I see only the original column names what I get from my Flat File source - COL001,COL002,COL003...

Why those new converted COL001_NEW,COL002_NEW,COL003_NEW

don't...

Jack,

I am trying to test your script

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Dim column As IDTSInputColumn90

...

Jack,

I just read your article at

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

and couldn't find how you pass the output from your Transformation Script to a database.

I don't know maybe it's very easy. I've never...

Thank you Jack.

But do I have to pass Error Output to some Custom Component

if for example my converssion from STR to DT_DATE failed?

I know already that it's a conversion failure....

Guys,

Thank you so much for your valuable input.

I definately will study the code Smunson posted.

It looks very interetsed.

But probably in my case it is a bit overkill.

I managed to get...

Thank you Jeck.

I'd like to learn more about this

"Configure Error Output" screen.

It has the following columns:

Input or Output

Column

Error (editable)

Truncation (editable)

Description

First of all I don't understand what Truncation...

I have a very clear understanding of how to do a Cross-Tab now.

How about Uncross-Tab?

Does anyone have any samples?

Thanks,

I'm more concerned at this point about READABILITY,

good LOGIC and try to AVOID REDUNDANCY.

Then I will take a closer look at Execution Plan.

From a quick view it looks like

79%...

The original query returned 504,994 records.

I re-wrote it.

But my version returns 504,600 records

I have to figure out why it returns a different number or records.

My version:

SELECT

cis.CIS_ID,

cis.CIS_ID as MASTER_OR_CIS_ID,

cur.cur_acct_num,

cur.ARRANGEMENT_CLASSIFICATION,

cur.CUR_ACCT_CRNCY_CODE,

srv.service_type_code,

cust_agrt.CUST_AGRMNT_NUM as...

Luke L,

What my STATS output tells?

Can you translate it for me please?

Luke L,

Thanks for a quick response.

So you think INNER JOIN will not help much

if I replace all those

WHERE

t1.c1 = t2.c1

...

We're working in a similar environment.

We design packages on our personal PC's,

use SSISConfig database on DEV SQL Server.

Then we move packages to PROD file location (\\TORD\PROD\SSIS\...)

and update SSISConfig database...