Chapter Summary

In this chapter, you learned about the range of DTS tasks that you can add to a package. You learned how to add additional functionality to the Transform Data task with the lookup query and learned how to use a Data Driven Query to add even more flexibility to your packages. It both cases, you were introduced to the use of ActiveX transformation scripts to enable this additional functionality at the Row Transform phase of the multiphase data pump. You were also introduced to the additional phases of the data pump that you can access in a package. Finally, you learned how to use the Execute Package task to begin creating a modularized data movement application.

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 © 2008-2017.
If you may any questions please contact us: