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 /SET propertypath;value option to the command prompt.
-
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.
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)
dtexec Utility
Other Resources
Command Prompt Utilities (Integration Services)
Running Packages
Help and Information
Getting SQL Server 2008 Assistance
