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