Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
grobin30
Starting Member
1 Post |
 Posted - 2012-03-15 : 09:57:58
|
| 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! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-15 : 16:23:40
|
| may be there are some unprintable characters at the end (CHAR(10),CHAR(13) etc? )------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS Redirect Rows - Blank Rows created