Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
DTS FAQ
The DTS FAQ is broken down into the categories listed below. This is not a general SQL Server FAQ, for that there are many other sites, see the General SQL Server page.

Administration & Management
Just because you have built your packages, it does not mean we can stop thinking about them. In this section we will show you how to move them about your environment, how to make sure that people can execute them and also how to make sure that should the server die your DTS packages live on

Connections
Connections are where our data is either coming from or going to. Some connection types you find in DTS have their own special way of doing things. In this section we address some of those features helping you to produce packages with the minimal amount of fuss. We also look at how to take charge of connections and make them work for you

Execution
We've built our packages and it all looks great in the designer window but now we want to actually make it move the data. In this section we show you how to execute DTS packages from a variety of calling programs such as ASP and VB to name but two.

Microsoft Knowledge Base
The Microsoft Knowledge Base or Technical database is a rich online resource covering all products. Listed below are some of the articles most frequently referenced on the DTS newsgroup. Searching the Knowledge Base

Tasks
Building a package using the wizards can solve your data transformation needs but what if you want to take it that one step further. In this section we show you how to make your DTS tasks more dynamic by responding to events around them or user prompted settings.

Troubleshooting
There are always going to be things that don't work first time, second time or even the fifth time but in this section we address some of the more common gotchas and provide the solutions allowing you to move on and create that work of art DTS package.

Workflow
DTS as the name suggests is about moving data. In this section we are going to show you how to make your DTS packages flow more, and make the moving of that data more dynamic, leading to greater code re-use and less work for you.

DTS Tutorials
In this section we present ways of building DTS packages and also how to use some of the functionality of DTS. We do it in the format of tutorials and hopefully there will be something for everybody in here.

SQL Server Integration Services

SQL Server 2005, previously known by the codename Yukon, is the next release of SQL Server, and as you might expect there are some changes. The first change to know about is there is a new name, no more DTS, now you have SQL Server Integration Services. To help organise our content and recognising the new name we have moved all relevant content to our new site SQLIS.com.

SQLIS.com