How to know in which line SSIS failed to parse the data from a flat file
|March 27, 2012||Posted by forumadmin under Database||
I have a flat file from which I am importing the data to a DB using SSIS. When the SSIS is failing it is just reporting that a particular column has failed importing. But to be more precise I want to know at which line in the flat file the error has occurred so that I can know where to search in the flat file.
Consider a flat file which has the following columns Name, age, Date. Assume that the file has 100 rows. But if SSIS failed at a certain row say 80 while processing the column Date. I am getting the error saying,
The “component “Derived Column” (19)” failed because error code 0xC0049063 occurred, and the error row disposition on “output column “DATE” (33)” specifies failure on error.
By this I am able to understand that column date has some non-numeric value. But how to know at which line SSIS failed (In this case it is Line:88)
I have to know this because I have large files so I am not able to understand where the error came while parsing.
Can anyone tel me what is 19 in “Derived Column” (19)” and what is 33 in “DATE” (33)” that I got in the error.
|Asked By – Amarnath||Read Answers|