CODEWITHSUNDEEP
sqlerror-handlingssis
KyorCode
KyorCode

Reputation: 1497

SSIS 2012 - Error output columnname

We are building a SSIS package for a customer where a lot of conversion checks happen in 1 dataflow task. We output any errors to a script that generates a new record for our Error-table. That error-table could then be consulted to check if any errors occurred.

We are aware that there are a few scripts and components out there to retrieve the real columnname from an error-output. But those are all for 2008 R2 or lower.

Secondly, we compared our 2012 xml with the 2008 R2, 2008 xml and there isn't any sign anymore of a lineageID, so we think that the scripts and components above will not function anymore.

Weird thing is though that in our designer in the advanced edit screen, we can see our lineageId's. Sadly, we fear that those are generated on runtime and can be different every run. So we can't script against those to retrieve the real columnname.

Anybody has any tips or tricks to resolve this?

Kind regards, Tom

Upvotes: 0

Views: 2933

Answers (1)

KyorCode
KyorCode

Reputation: 1497

Benny Austin's solution

This provided me with an answer. Do read the comments about the package though, you might need to fiddle somethings before it works. But eventually it does.

Upvotes: 1

Related Questions