SQL Server Performance

Advanced features for DTSs?

Discussion in 'SQL Server DTS-Related Questions' started by Joozh, Apr 17, 2006.

  1. Joozh New Member


    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????

  2. aki_aki New Member

    The BOL has a good amount to info .....
  3. dineshasanka Moderator

  4. Joozh New Member

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

Share This Page