Hi proctor,

i used derived column transformation and i used below expression

(DB_DBDATE)(Substring(columnname,5,2)+"/"+Substring(columnname,7,2)+"/"+substring(columnname,1,4))

it works fine and change the date (2006-02-28) but it didnt change datatype

and one more thing is in my source i have 100 columns in this columns 25 columns are '00000000' how to import this columns into destination

i searched every forums but i didnt get any related matter