Hi, Since I am new to DTSs therefore currently I am making my DTSs in a manner where there probably is a room for improvement e.g. When I have to Import data from one server to another I use the Import feature and then I go through all the steps of the wizard (at the end of which I get the option to save my DTS).... In the DTS "design window" there are many options under the TASK menu option and is there a url from where I can learn how to use these options (under TASK i.e. File Transfer Protocaol task, ActiveX Script Task, Transform Data Task, etc. etc.). Maybe if I know how to use these options, I might be able to write my DTS in better and flexible manner... Hope my posts is making some sense???? Thanks
www.sqldts.com is another good place for DTS ---------------------------------------- http://spaces.msn.com/members/dineshasanka