SQL Server Performance Forum – Threads Archive

Advanced topics/features/usage of DTS’s

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.

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

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.

It is time for SSIS not DTS <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> 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> Book "Professional SQL Server 2000 DTS (Data Transformation Service)" http://www.sqldts.com/600.aspx</a> MohammedU. Moderator SQL-Server-Performance.com

Thank You MohammedU. Sorry if I am not getting the joke but what is SSIS?

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

]]>