Chapter Summary

In this chapter, you learned how to use DTS Designer to view, edit, and create the building blocks of DTS packages: connections, tasks, and precedence constraints. You also learned about the difference between dedicated and shared connection objects, and about the most commonly used tasks in a data movement application: the Transform Data, the Execute SQL, and the Bulk Insert tasks. You learned that tasks execute in parallel unless you use precedence constraints to control the order of task execution in a package. Finally, you created the first two packages that will become a prototype of a data movement application. In the next chapter, you will learn how to work with the packages you have created.