Jonathan , could you let me know how to do it by Dynamic SQL.

Thanks Jonathan, article was of much help.

At  one thing i am still stuck , is that when i join Source Text File and Destination Server by  Transform Data Task , it...