Decimal Formatting from OLEDB Source to Flat File

I have a table with column (call it Rate) defined as decimal(18,4). This column can have any positive decimal value. When the value is less than 1 (e.g. 0.1234) strange things are happening in SSIS.

To set the scenario ...

If I do a select in Management Studio, the value is correctly displayed as 0.1234

If I do the same select from the command line via OSQL, I get .1234

If I do SELECT CONVERT(char(6), Rate) from OSQL, I get 0.1234 (which is what I want)

In SSIS I have an OLE DB Source which defines the SELECT statement to use, and that maps straight to a Flat File Destination.

The default column type in the flat file connection manager is DT_NUMERIC, Precision 18, Scale 4. I Set InputColumnWidth to 6 as that's how I need it in the flat file. The value appears in the file as .1234

I change the SELECT in the OLEDB Source to apply the CONVERT(char(6), Rate), and change the column type in the connection manager to DT_STR length 6. Output is *still* .1234

How can I get the output column in my file to show 0.1234 ?

Greg.
Restarting this thread to check for any new information.

Greg.

|||have u tried Currency datatype|||Yes. It made no difference.

Greg.