Derived Column hung up

• tuktukg

  SSC Enthusiast

  Points: 139

  More actions

  February 26, 2016 at 2:52 pm

  #324550

  i have an input column CallDate from my source as VarChar (ex 02-15-2016).

  I have a column DayID in my destination as INT.

  Inut an output Prop from my Derived COlumn is :

  Input Column: Code Page 1252 DataType DT_STR.

  My Derived Colunmn Name = DayID.

  Derived Column is default

  The expression im trying is

  EXRESSION: SUBSTRING(CallDate,7,4) + SUBSTRING(CallDate,1,2) + SUBSTRING(CallDate,4,2)

  which set the

  Data Type to: eigth-byte signed integer DT_18]

  it appears to run but then get huge up and doesn't finish.....ANY IDEAS??? I'm guessing my expression / data type is incorrect.

  I appreciate the help.

  T

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  March 1, 2016 at 8:55 am

  #1862126

  I haven't tested this, but give this a try.

  Change your derived column to DT_I4, you don't need the larger integer.

  Try this expression (DT_I4)(REPLACE((DT_WSTR, 10) (DT_DBDATE) CallDate),"-","")