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.

Answer this question

Decimal Formatting from OLEDB Source to Flat File

PanosTz
have u tried Currency datatype
Fred Stegemann
Yes. It made no difference.

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

Greg.
Decimal Formatting from OLEDB Source to Flat File

Answer this question