above sample data

convert customer key into integer

convert custdt into date

any help appriciated

thanks

vasu

sorry for the late response

this is my sample data

Customer Key Customer no ...

Hi

Any Body help appriciated

Hi

i used data conversion transformation instead of derived column but it getting below error

Error:The Conversion returned status value 2 and status text "the value could not be converted because...

its working fine

Thanks to GilaMonster and everyone who reply this qustion

Hi john

it is my sample data of old column

primary key oldcolumn

----------- ---------

023456781 20050428

023456782 20040112

023456783 20061228

023456784 ...

i am really sorry...proctor

hi,

i used above expression in derived column but it came same problem

it didnt change datatype

and what is "import into a temp table as a varchar and do the sql to...

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...

hi hodgy

i used error output.all rows went to error output

in error output

errorcode:-1073442796

errocolumn;11519

errordescription:an error occured during computation of the expression

tell me related solve

sorry for the inconvience plz reply its urget

sorry for the late replay

hi hodgy

what u suggested i implement in the derived column (DT_14)(Customer no) at the execution time it showed following error.

[Derived Column [2149]] Error: An...

Hi hodgy

what u said is correct.it doesn't change the column.but at the same time my datatype also will be converted(from string to integer) that is my main problem.for that purpose...