March 15, 2012 at 1:08 pm
Hello,
I am using the "Redirect Row" option for any rows that error out. The step is working correctly. The errored rows are being redirected as expected.
However, the output file populated with the errored rows is being created with a blank row between each errored row. There are no blank rows in the source file, which is a .txt file.
Any suggestions?
Thanks!
March 16, 2012 at 1:40 am
The flat file connection manager for the error file, what is it's row delimiter?
What are you using to view the error file?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 9, 2012 at 6:24 am
Hi,
I also face the same issue where errored rows is being created with a blank row between each errored row.
My Source file is Comma separated CSV file.
I am re-directing the Error output to another FlatFile (csv). In the Error output, i see the following 3 columns :
Flat File Source Error Output Column , ErrorCode, ErrorColumn.
During the FlatFile Conn Manager setup for Error File, i just retain only one column "Flat File Source Error Output Column".
Even after this, i get a blank row between each errored row.
Appreciate your help to resolve this blank row issue.
Thanks,
Arun
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply