The DTS Wizard is provided with both SQL Server and MSDE. The Enterprise Manager in SQL Server also provides additional options for creating and processing DTS packages using the DTS Package component.
The next section describes how the DTS Package option can be used to create a DTS package that manipulates data in the tblProductSales table and exports it to an Access database.
DTS Package, displayed in Figure 22-8, is launched in SQL Server Enterprise Manager from the branch of the active SQL Server by right-clicking Data Transformation Services, then New Package.
To transfer data, DTS Package needs at least three pieces of information:
The data source (in ...