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 a text, fixed length field, I’ll call recptamt and define as numeric, (10,2)
I need the value left-justified so that it would fill the field with ‘ 123.45’
It comes out as ‘123.45 ‘
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 a text, fixed length field, I’ll call recptamt and define as numeric, (10,2)
I need the value left-justified so that it would fill the field with ‘ 123.45’
It comes out as ‘123.45 ‘