O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

DTS in Enterprise Manager

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

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.

Figure 22-8. DTS Package designer window

To transfer data, DTS Package needs at least three pieces of information:

  • The data source (in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required