Decimal limited to 4 digits to right of decimal?

I need to store decimal values: decimal(20,15) in my SQL Server 2005 database.

I load data from flat file, convert it using Data Conversion Task to decimal(with scale: 15) and try to save it using OLE DB Destination.

It works fine for 4 digits after the decimal (like 1.1234), but always failes for more than 4 digits (1.12345).

Is the decimal limited to scale 4 ?

Thank you for your help!

Anna

Nope. Should work. What is the error?|||

I got:

Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client"
Hresult: 0x80004005 Description: "Invalid character value for cast specification".

Error: There was an error with input column "MyDecimalColumn" (10464) on input "OLE DB Destination Input" (10388).
The column status returned was: "Conversion failed because the data value overflowed the specified type."

Anna

|||That would indicate the destination in SQL is two small. What is it defined as?