Database Reference
In-Depth Information
17-1 provides a summary of the options related to running packages from projects
stored on the file system.
Table 17-1 . DTEXEC Command-Line Options for Using Project Files (.ispac)
Parameter
Description
Proj[ect]= path_to_project
This option provides the path to the SSIS project file ( .ispac ).
Example: /Proj c:\demo\project.ispac
Pack[age]= package_name
The name of the package within the project file you want to run. The
value should include the .dtsx extension.
Example: /Pack MyPackage.dtsx
Set= parameter_name;value
This option allows you to set a value for a parameter within the project.
The syntax is similar to what you'd use to override package variable val-
ues on the command line. Use the $Project namespace to set values
for parameters defined at the project scope, and $Package for paramet-
ers defined at the package scope.
Example:
/Set=\Package.Variables[$Project::IntParameter];1
Conf[igFile]= path_to_file
This option allows you to set multiple parameter values from an XML
configuration file. The syntax for each parameter value is similar to what
is used for the /Set option.
Example: /Conf parameters.xml
Listing 17-3 provides an example of running a package ( MyPackage.dtsx ) con-
tained within a project file ( project.ispac ). It sets the values for two paramet-
ers— BatchNumber , an integer parameter defined at the project level, and
HostName , a string parameter defined at the package level.
Listing 17-3 . Running Packages Within a Project File Using DTEXEC
dtexec.exe /Project c:\demo\project.ispac /Package
MyPackage.dtsx /Set
\Package.Variables[$Project::BatchNumber];432 /Set
\Package.Variables[$Package::HostName];localhost
Note Although the syntax for setting parameter values is similar to setting values for
variables and other package properties, there is one key difference. To set parameter val-
 
 
 
Search WWH ::




Custom Search