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.




Microsoft SQL Server 2000 DTS Step by Step
Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))
ISBN: 0735619166
EAN: 2147483647
Year: 2003
Pages: 87
Authors: Carl Rabeler

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net