Advanced features for DTSs? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Advanced features for DTSs?

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
The BOL has a good amount to info ….. is another good place for DTS —————————————-

Thanks <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />