Data Conversion Wrror Output
I am attempting to convert 2 fields/columns within the data conversion task. I have configured the error output to redirect the error rows.
I have noticed one issue with the error output.
I know for a fact that there will be errors in both fields but once it notices errors in field1 it redirects the rows but then it ignores the error rows for field2. Therefore you never get a full representation of the errors because it can only redirect
one field at a time even though it claims to allow you to redirect multiple fields.
Can someone please tell me how to resolve this issue or any other alternative methods. Thanks In Advance
May 11th, 2011 11:33am
I believe this work like logical operator OR which ever column returns error first then entire row will be redirected with out checking other column valueshttp://uk.linkedin.com/in/ramjaddu
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 2:54pm
Do two (sequential) (linked) Data Conversions.Arthur My Blog
May 11th, 2011 2:55pm