i think you did not select all these tools at the times of installing sql server 2005.while installing sql server 2005 at one place you have to go to advanced...

yes this is working thank you for your answer

Thank you very much for your reply.

Its working fine when i extract the data from oledb source.

but my source is flatfile.I am trying to extract the data from flat file,...

thanks for your answer.

But this answer is not working in ssis 2005,when i used it as expression in derived column.So, can you plesase help me is there any other option...