July 29, 2010 at 12:40 pm
I'm a relative newbie with SSIS in SS 2005. I have learned some of the basics about logging using SSIS, but I cannot figure out how to log a bad record.
In other words, let's say I've got a text file with a 1,000 records and 2 of those records are bad and can't be loaded. I'd like for 998 to go into the table and the 2 bad records to get written out to another file for inspection later.
Is this possible? If so, how can I do this?
July 29, 2010 at 2:45 pm
In other words, let's say I've got a text file with a 1,000 records and 2 of those records are bad and can't be loaded. I'd like for 998 to go into the table and the 2 bad records to get written out to another file for inspection later.
Is this possible? If so, how can I do this?
This is possible. In the data flow task you need to redirect the bad records (arrow with the red color) to the data flow destination in order for those records to get inserted into either a table or file.
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply