Review

The following questions are designed to reinforce key information presented in the chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. Answers to the questions can be found in Appendix A: Questions and Answers.

1. Where can DTS packages be stored?
2. What is the main benefit of storing DTS packages in the Microsoft Repository?
3. What are the components of a package version, and when are they generated?
4. What are the possible passwords on a package, and what effect do they have?
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?

Answer