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