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