Chapter Summary

In this chapter, you learned how to enable properties in your packages to be dynamically configured at run time without opening and editing each package. You learned how to use data link connection objects, an initialization file, global variables , and Dynamic Properties tasks to dynamically control the execution of tasks and the configuration of connection objects at run time. Furthermore, you learned two methods for setting global variable values in a subpackage from a master package. In the next chapter you will learn how to use an ActiveX Script task to set global variable values in the packages in the 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: