Configuration - SQL Server Integration Services Design Patterns - page 423

/Password command-line options cannot be used with the /ISServer option. If
you need to impersonate another user account, you can use the RunAs DOS command
with DTEXEC.
When you run an SSIS Catalog package with DTEXEC, it will run in an asyn-
chronous mode by default. This means that the process will return immediately and
will not tell you whether the package actually ran successfully. To get synchronous ex-
ecution behavior (e.g., the same that you would get when running packages from the
file system or MSDB), you need to include the /Par "$ServerOp-
tion::SYNCHRONIZED(Boolean)";True command-line switch. When syn-
chronous execution is used, the DTEXEC process will not return until the package has
finished running.
Another difference between the SSIS Catalog and other forms of DTEXEC execu-
tion is that the events that occur while the package is running are not displayed on the
command line. Listing 17-4 shows a sample output from running a package in the SSIS
Catalog—as you can see, there is only a single message telling you the server execu-
tion ID and pointing you to the catalog reports.
Dynamic Configurations
Parameters on an entry-point package allow a user to specify values, but they require
that the values be known before the package starts running. There may be times where
you'll need to determine configurations at runtime or dynamically pull in values from
other sources (such as an external file or a database table). The following sections
provide design patterns that you can use to augment the capabilities provided by the
parameter model.
Configuring from a Database Table
The SSIS Catalog provides a central location for package configuration values, but
your environment may already have alternative locations that store metadata that your
packages need at runtime. This pattern shows you how to retrieve values from a data-
base table using an Execute SQL task and how to configure properties within the pack-
age using property expressions. For this example, you'll be reading a directory and file