Converting from DT_WSTR to DT_NUMERIC

  • 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?

  • 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