SQL Server Performance

Advanced topics/features/usage of DTS's

Discussion in 'SQL Server DTS-Related Questions' started by Joozh, Mar 13, 2007.

  1. Joozh New Member

    Hello,

    I know the basics of DTSs and have been using them for a while. Now I REALLY want to learn the advanced concepts related to DTS's e.g.


    • 1. How to make use of the "Inner Package Global Variables" Tab (which is visible in the DTS Designer "window")

    • 2. How to make use of the "Outer Package Global Variables" Tab (which is visible in the DTS Designer "window")

    • 3. How to make use of the "Outer Package Global Variables" Tab (which is visible in the menu bar option #4 Designer "window")

    Many many advance thanks for your help.
  2. madhuottapalam New Member

    http://www.sqldts.com/ is one of the best site available for DTS

    Madhu
  3. Joozh New Member

    Thank you for the reply madhu. Will try your URL. Please do share if you can think of specific and excellent articles related to my request.
  4. MohammedU New Member

    It is time for SSIS not DTS <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Data Transformation Services (DTS) in SQL Server 200<a target="_blank" href=http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/dtssql2k.mspx>http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/dtssql2k.mspx</a><br /><br />Book "Professional SQL Server 2000 DTS (Data Transformation Service)"<br /<a target="_blank" href=http://www.sqldts.com/600.aspx>http://www.sqldts.com/600.aspx</a><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com
  5. Joozh New Member

    Thank You MohammedU.

    Sorry if I am not getting the joke but what is SSIS?

  6. MohammedU New Member

    In SQL SERVER 2005 there is no more DTS....
    Now in sql 2005 it is called SQL SERVER INTEGRATION SERVICES (SSIS) which complete ETL tool...So it is better to learn SSIS instead of DTS...

    Read the following for more details...

    http://msdn2.microsoft.com/en-us/library/ms141026.aspx
    http://www.sqlis.com/

    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page