Hi

I am using SSIS to import data from a flat-file into a SQL server table. One
of the columns contains a decimal quantity which maps to a decimal(18,2) row
in the table.

When I do a preview on the source flat file component it returns the correct
data, i.e.:
45.87, 21.56, ...

However, when I do a preview on the destination SQL server componenet or
actually run the package, I'll end up with the following values:
45.00, 21.00, ...

I've opened the advanced editor on the detination and set the scale to 2 (it
was 0 by default) on the external column details. This made no difference.

I also checked the column type on the flat file source and this is set to
DT_DECIMAL.

I am running out of ideas here. If anybody knows of a way to ensure this
works consistantly, please could you assist.

Many thanks

Al