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