ssis Derived column error

• div4u22

  Old Hand

  Points: 339

  More actions

  May 15, 2011 at 6:07 pm

  #239538

  I am trying to load csv file into a sql table through ssis.I am using derived column as below:

  (TRIM([col1]) == "" ? NULL(DT_NUMERIC,27,6) : (DT_NUMERIC,27,6)[col1])

  It gives the following error:

  [Derived Column [220]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Derived Column" (220)" failed because error code 0xC0049063 occurred, and the error row disposition on "output column "dc_col1" (2466)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

  Any help appreciated.

  Thanks

• Todd McDermid

  Default port

  Points: 1416

  More actions

  May 16, 2011 at 9:48 am

  #1325211

  What data type is [col1], what possible values are in [col1], and are you creating a new column?

  Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
  My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components