I’m doing a Data Transformation Service extract of data under MS-SQL 7.0. I have two fields that are numeric. I need to extract them to a text, fixed length file. When I extract them – I can get them to the right field(column), but they export in a ‘right-justified’ format.
Ie. From database table: Receipt_amount defined as decimal (19,7) has a value of ‘123.45’
When I extract, I want it to go into...