Fixed width output problem

Hot Topic

Money conversion
SQL Express user permissions?
Device error or device off-line ???
SQL Server 2000 Reporting Services and Importing Access Reports
referenced relationship error
Keep getting Virtual Memory errors
Execute a package on a remote server
SQL Server 2005 Express: Weird error message running SELECT COUNT query
sql server 2005 error handling
"Beta period is over" (June 2005 CTP)

SQL Server

How Do I Start New SQL Server 2005 Database?
How do you edit a Group with no header or footer?
Dynamic loading of a file
dtexec hangs unexpectedly
Issue incorporating third parameter in report
sql mobile question
Error while launching the report builder
Work tables/bookmark lookups
SQL escalating S lock to IX by itself and later Deadlocking
Return more than 4000 characters from CLR stored procedure

Fixed width output problem

I'm sending the results of an SSIS data flow to an fixed-width flat file output, but instead of getting separate rows of data, like so:

row1data...
row2data...
row3data...
etc...

I get:

row1data...row2data...row3data...etc...

Is there some setting I'm missing in either the flat file output or the file connection to turn this on

Answer this question

Fixed width output problem

bfellner

The fixed width format does not include the row delimiters.

You can use the Ragged right format if your last column always has a fixed format or you do not care for it to be fixed.

If you do have a requirement for the fixed length of the last column (like you always want integer values to take 10 characters in the file), you can create your Flat File Connection manager by clicking "New..." on the Flat File Destination UI and choose the "Fixed width with row delimiters" option. That will actually create the ragged right file with a dummy row delimiter column.

HTH.
vpeh
Thank you. That's what I needed.
Fixed width output problem

Answer this question