Chapter 8

Advanced DTS

Review Questions

1. Where can DTS packages be stored?

In Microsoft Repository, SQL Server, and COM-structured files

2. What is the main benefit of storing DTS packages in the Microsoft Repository?

If a DTS package is stored in the Microsoft Repository, the metadata for the package is available to repository tools and data lineage can be tracked for the package.

3. What are the components of a package version, and when are they generated?

Package ID is generated when the package is created, and version ID is generated when the package is created and whenever the package is updated.

4. What are the possible passwords on a package, and what effect do they have?

The owner password is required to view or edit the package, and the user password is required to execute the package. When passwords have been set for the package, the package contents are stored in an encrypted format.

5. In your DTS package, you have created a SQL task that drops the indexes on a number of tables. You have also created three data transformations. The SQL task must run before the three data transformations run. What must you do to ensure that the package executes correctly?

Add success precedence constraints from the SQL task to each of the data transformations. To do this, perform the following steps for each data transformation. Highlight the SQL task and the source connection for the data transformation. Right-click the connection and select Success on the Workflow submenu.