my project is insert data to OLE DB destination from csv file.
my question is
how can I get the row number(error row) while constraint failure at the OLE DB destination?
thanks.
You can't. There is no concept of row numbers in the SSIS pipeline (for good reasons).
What you CAN do is divert the erroring rows elsewhere for examination later.
-Jamie
|||thank you.
it saves me a lot of time.
|||What good reasons ?
No comments:
Post a Comment