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
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