March 1, 2012 at 3:53 pm
I'm creating a SSIS package to load data from a CSV file into a SQL table. One of the fields in my destination table is a DECIMAL (10,2). When I run my package it fails out on of this field due to truncation. I converted the field in the data source to string and created a derived column for it that trims out any whitespace and then converts it to a DT_NUMERIC (10,2). The package now fails on the derived column saying it cannot perform the CAST. Here is the line of code for the derived column: (DT_NUMERIC,10,2)LTRIM(RTRIM([Autolink Standard Hours - Job Dta]))
According to what I've seen online I should be able to make this conversion. I've also double checked the field in the CSV file and there are no strange characters in the field. What am I doing wrong?
March 5, 2012 at 12:54 am
Can you post the error messages?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy