I took lookup component in data flow and used TFS database connection and selected contacts table and SID field of it but it does not give me any functionality by...

Thanks Alexander.

It worked...I had to amend some logic because all the records were added in my source database from CLARION which has some different base date n time.

Thank u for...

Thanks for putting the efforts in resolving my problem.

Actually I am storing integer values of date and time in source table in following way:

UPDATEDATE: Integer: values like 75602, 75591 etc...

I am using "Derived column Transformation" in Data flow of my package.

I tried it out using the way u have mentioned in following manner:

(DT_DBTIMESTAMP)[ (DT_STR, 8)UPDATEDATE + (DT_STR,9) UPDATETIME]

Here UPDATEDATE...