|
|
Professional design of DTS packages
(5 advanced tricks that you should know about SQL Server DTS packages
to make them professional grade)
You have used basic features of Import
and Export Data wizard and
Data
Transformation Services (DTS)
in SQL Server 2000, but there is more
that you need to master before you can develop professional grade packages:
- Deployment on
production server
- Setting connections in production
environment
-
Editing package, connection, step and
task properties at run-time
- Execution of other DTS packages
- How to speed up
data
loading
- Using global variables
- Parameter queries
Changing the location of
DTS packages
Handling multiple versions
of DTS package
Setting parameters at run-time
Parallel processing
Looping in DTS
Execute DTS package from command
line
Performance improvement tips
|
