Flat File Connection "Fixed Width" not Fixed RRS feed

  • Question

  • 2008 R2

    I developed a package which writes a fixed-width format flat file, a first for me.  In my data source I have a query which builds a single-column and appends 0D0A after every 300 characters.  The result was a file with 300 character lines followed by crlf for a total of 302 per line.  This was good.

    When I moved the package to production, the lines were no longer all 302 in length. Some of the lines where 4 characters longer. The only way to get the lines back to 302 was to change the Format to "ragged right" and remove the 0D0A from my query.  Since the query always returns  300 character rows, the result is a 302 line length (including 0D0A provided by the connection). We are back to good.

    But I am taking a lot of heat for this.  We are running two slightly different versions of SQL Server on the two platforms, and we have noticed other issues with Flat File Connections when we move packages from dev to prod.  I am wondering if this is another symptom of two different versions of SQL Server? 

    Any comments?

    Dev:  10.50.2500.0

    Prod: 10.50.1600.1

    Best regards

    Thursday, October 3, 2013 5:55 PM


  • There were KBs in SP1 concerning the Flat File Connection manager issues, don't know what specifically might have had an effect on the issue you not experiencing in Dev, but since the prod is behind on two SPs you should upgrade it.

    It is a common practice to have Dev and Prod aligned.

    Arthur My Blog

    • Proposed as answer by Mike Yin Tuesday, October 8, 2013 4:31 PM
    • Marked as answer by Mike Yin Sunday, October 13, 2013 3:31 PM
    Friday, October 4, 2013 5:45 PM