| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | |
|---|---|---|---|---|---|---|---|---|---|
General Page of Integration Services Designers Options |
General Page of Integration Services Designers Options |
chugugrace |
chugu |
03/14/2017 |
sql |
integration-services |
conceptual |
|
[!INCLUDEsqlserver-ssis]
Use the General page of the Integration Services Designers page in the Options dialog box to specify the options for loading, displaying, and upgrading packages.
To open the General page, in [!INCLUDEssBIDevStudioFull], on the Tools menu, click Options, expand Business Intelligence Designers, and select Integration Services Designers.
Check digital signature when loading a package
Select to have [!INCLUDEssISnoversion] check the digital signature when loading a package. [!INCLUDEssISnoversion] will only check whether the digital signature is present, is valid, and is from a trusted source. [!INCLUDEssISnoversion] will not check whether the package has been changed since the package was signed.
If you set the BlockedSignatureStates registry value, this registry value overrides the Check digital signature when loading a package option. For more information, see Implement a Signing Policy by Setting a Registry Value.
For more information about digital certificates and packages, see Identify the Source of Packages with Digital Signatures.
Show warning if package is unsigned
Select to display a warning when loading a package that is not signed.
Show precedence constraint labels
Select which label-Success, Failure, or Completion-to display on precedence constraints when viewing packages in [!INCLUDEssBIDevStudioFull].
Scripting language
Select the default scripting language for new Script tasks and Script components.
Update connection strings to use new provider names
When opening or upgrading [!INCLUDEssISversion2005] packages, update connection strings to use the names for the following providers, for the current release of [!INCLUDEssNoVersion] [!INCLUDEssISnoversion]:
-
[!INCLUDEssASnoversion] OLE DB provider
-
[!INCLUDEssNoVersion] Native Client
The [!INCLUDEssIS] Package Upgrade Wizard updates only connection strings that are stored in connection managers. The wizard does not update connection strings that are constructed dynamically by using the [!INCLUDEssISnoversion] expression language, or by using code in a Script task.
Create new package ID
When upgrading [!INCLUDEssISversion2005] packages, create new package IDs for the upgraded versions of the packages.
Security Overview (Integration Services)
Extending Packages with Scripting