Converting from DT_WSTR to DT_NUMERIC

• civicman4

  SSC Veteran

  Points: 282

  More actions

  March 1, 2012 at 3:53 pm

  #253989

  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?

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  March 5, 2012 at 12:54 am

  #1454661

  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