Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Migrating Variables

In Integration Services, a variables collection is available on all containers: packages, looping structures such as the Foreach container, and the TaskHost container that encapsulates each task. When a package is migrated, the global variables and the variables from SQL Server 2000 DTS tasks are all migrated to the variables collection of the package. For example, the variables used by a SQL Server 2000 Execute SQL task are added to the variables collection of the migrated package.

Integration Services uses namespaces to organize variables. All DTS variables are migrated to the User namespace.

After the package is migrated, you can add functionality to variables in the following ways:

  • Create additional namespaces and organize variables by namespace.

  • Use expressions to set variable values.

  • Specify whether updating the variable value raises an event.

For more information, see Integration Services Variables and Using Variables in Packages.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.