I am trying to import an Excel file, but receiving the following error when one of my numeric columns has a value greater than 999. There was an error with input column "MyID" (14053) on input "Destination Input" (87).The column status returned was: "Conversion failed because the data value overflowed the specified type.". The package is simple, having: 1. Source (Excel file) 2. Data Conversion 3. Destination (SQL Server table) The Conversion step changes the ID input to decimal [DT_DECIMAL] with a scale of 2. The SQL table field is defined as Decimal(5,2). If the number in my Excel file is 999 or less the package works. Anything greater and it fails. I've tried changing the type to Numeric(5,2) but no change. Thanks

Hi, Seems: Decimal 5,2: xxx,yy (Five placeholders and two of it is scale) Decimal 6,2: xxxx,yy So try to increase it. Senior BI Consultant & PM @ Nexum Bogazici If it is, Please dont forget to mark as answered or at least vote as helpful if the post helps you in any ways.

I tried changing the SQL table to Decimal(7,2) but still had the same problem. I also tried changing the output type in the Conversion and Destination processes to Numeric(7,2) but still receive the same error.

Decimal and Numeric are the same. The issue is with the target column definition - it simply does not accept more than 5 digits, bit the data from Excel is not coming out right, perhaps it is like 999.000 ? Check using a Data Viewer.Arthur My Blog

The Data Viewer is showing: 1000.00

Sorry, my Configuration file was pointing to a different server with an older and smaller datatype. Changing it to the correct server works now. It works fine now.