Execute Package Utility (Set Values Page)

Use the Set Values page of the Execute Package Utility dialog box to set the property values of packages, executables, connections, variables, and log providers by typing the paths of properties and the property values. Each path entry adds a /SETpropertypath;value option to the command prompt.

Options

  • Property Path
    Type the path of the property. The path syntax uses a backslash (\) to indicate that the following item is a container, the period (.) to indicate the following item is a property, and brackets to indicate a collection member. The member can be identified by its index or its name. For example, the property path of a package variable is \Package.Variables[MyVariable].Value.
  • Value
    Type the value of the property.
  • Remove
    Select a property path and click to remove it.
  • Execute
    Click to run the package.
  • Close
    Click to close the Execute Package Utility dialog box.

See Also

Reference

Execute Package Utility (General Page)
Execute Package Utility (Configurations Page)
Execute Package Utility (Command Files Page)
Execute Package Utility (Connection Managers Page)
Execute Package Utility (Execution Options Page)
Execute Package Utility (Reporting Page)
Execute Package Utility (Logging Page)
Execute Package Utility (Verification Page)
Execute Package Utility (Command Line Page)

Other Resources

Command Prompt Utilities (SSIS)
dtexec Utility
Running Packages

Help and Information

Getting SQL Server 2005 Assistance