Database Reference
In-Depth Information
after making updates to your configurations to make sure that you do not lose the
changes.
Specifying Entry-Point Packages
SQL Server 2012 introduces another new concept for SSIS—the entry-point package .
This feature allows the package developer to indicate that special attention should be
paid to certain packages. This is very useful in projects that contain a small number of
master packages that run a number of child packages. Note that packages that are not
marked as entry-point packages can still be run—the setting is meant to be a hint for
the person configuring parameter values in the SSIS Catalog. Most SSIS UIs in SQL
Server Management Studio (SSMS) allow you to quickly filter out parameters on non-
entry-point packages, allowing you to view only the parameters they need to set.
Packages are marked as entry points by default. To remove this setting, right-click
on the package name in the Solution Explorer, and unselect the Entry-Point Package
option.
Connection Managers
Most connection managers will require some form of configuration, and in SQL Server
2012, all connection manager properties are configurable when packages are run
through the SSIS Catalog. Since these properties are already exposed, in most cases,
you will not need to expose additional parameters for your connection managers.
However, you may encounter some scenarios where parameterized connection man-
agers will be beneficial. Note that any connection manager property that is set via ex-
pression will not be exposed through the SSIS Catalog, which prevents a DBA from
accidentally overriding property values that are set at runtime.
Note In previous versions of SQL Server Integration Services, it was common for
child packages to configure connection managers with variable values from the parent
package. You may wish to keep this pattern in SQL Server 2014 if the connection string
is determined at runtime; however, in many cases, you'll want to use shared connection
managers instead.
Search WWH ::




Custom Search