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.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  package not seeing end of record

Author  Topic  cronid Starting Member 26 Posts Posted - 2007-04-09 : 16:17:20 I am trying to create an 11 character record in a flat file destination, where the first 9 characters are variable values and the last 2 characters are the literal "|Y". When I look at it for the preview in the flat file editor, the records are fine but when I execute the package it creates a single record where the 11 characters are being appended. The HeaderRowDelimiter is defined as carriage return, line feed and the columns are correctly delimited and mapped in the flat file editor. I am using data flow to create the file. It works against a sql server table filtering for rows where an amount field exceeds 9999 for the variable portion and a derived column with the fixed literal '|Y' is created. I'm expecting records like: 073902108|Y 101137107|Y 704549104|Y but I'm getting a single record wrap around like this: 073902108|Y101137107|Y704549104|Y035229103|Y101121101|Y The connection is described as fixed width. When I preview it in the advanced editor, the file looks correct. When I look at the columns option, the ninth position has a black line and the 11th has a red one. But the output is not correct. Does anyone see what the problem is and how to correct it?