Hi peter thanks for u suggestion.

i did what u suggested and i implement expression in derived column transformation.

the expression is:

(ISNULL([date string])) ? NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)(SUBSTRING([date string], 7, 4) + "-" SUBSTRING([date string], 1, 2) + "-" + SUBSTRING([date string], 4, 2))

and my client asked me load data in target like this

1.2006-10-26(Date Datatype)

2.2006-11-15

3.2007-07-12

4.0

5.2007-12-04

6.2007-09-22

7.0

8.2008-01-24

what is the expression i have to write in derived column trasnformation

thanks

murali