Wednesday, March 21, 2012

Getting row order in Input File when Handling Errors

Hi All,

Well, tha case here is simply that i have a (Suppliers.csv) as an Input.

When taking that file, I do some validation on it's rows (Data type validations, Mandatory Fielda validations..etc).

When some rows to do not meet the requirments i put in these validations , it is supposed to be directed to an (Errors) Table in my SQL DB.

I want to include the order of the invalid row in the input File (The row which did not pass from the pre-mentioned validations) within the (Errors) Table when i direct the invalid rows to it.

Any ideas ?

See the script in my post on surrogate keys.

http://www.ssistalk.com/2007/02/20/generating-surrogate-keys/

Place that at the beginning of your data flow to number all rows passing through it. Then in the error flow, you'll have the correct row number.

No comments:

Post a Comment