Thanks again.

I am redirecting rows and nothing in the text file stands out since I manually took the data that failed and inserted into the table without issue.

In SSIS...

Thank you for your quick response.

I am logging the errors to a text file which display:

1. error code - the negative number I posted

2. error column - always zero

3. error...