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