October 13, 2015 at 11:45 pm
Hi,
In my package source is flat file, now I want to redirect bad rows to error output with the line number.
suppose below is my data
ID,NAME,AGE
1,AA,30
2,BB,25
3,CC,30
4,DD,a
Column data type :- ID=Int , NAME=Varchar(100) and AGE=Int data type.
as you can see that 4th row have incorrect data , having char in int column data type.
I am able to redirect the bad data to error output , but unable to get the line number and error column name in error output file.
Kindly help me to achieve above scenario.
October 14, 2015 at 4:22 am
To get the column name is a bit fiddly but possible (unless you have a time machine and are using SQL 2016 where it's been made simple finally[/url]. Also, who wins the rugby world cup?) and is explained here:
https://bennyaustin.wordpress.com/2011/02/04/ssis-name-of-errorcolumn/
As far as a row number goes, I suppose one way to do it would be to pre-process your flat file (before it hits the DFT) to add a row number with a script task and then output this along with the rest of the error columns.
October 14, 2015 at 5:03 am
Ok,
Can I get the error line number in my error output file.
Regards,
Vipin
October 14, 2015 at 5:20 am
PB_BI (10/14/2015)
To get the column name is a bit fiddly but possible (unless you have a time machine and are using SQL 2016 where it's been made simple finally[/url]. Also, who wins the rugby world cup?) and is explained here:https://bennyaustin.wordpress.com/2011/02/04/ssis-name-of-errorcolumn/
As far as a row number goes, I suppose one way to do it would be to pre-process your flat file (before it hits the DFT) to add a row number with a script task and then output this along with the rest of the error columns.
Thanks for the link.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply