Hi there,
I have a DTS package that is exporting data from SQL Server to
a text file. I have selected Fixed Field on the Text File Destination
properties and defined the column lengths on the Transform Data Task.
However, when the package runs, it completely ignores the column lengths
that I have defined and uses the database field lengths instead. Anyone
else had this problem?