Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

General Page

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 Business Intelligence Development Studio, 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 Integration Services check the digital signature when loading a package. Integration Services will only check whether the digital signature is present, is valid, and is from a trusted source. Integration Services 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 How to: Implement a Signing Policy by Setting a Registry Value.

For more information about digital certificates and packages, see Using Digital Signatures with Packages.

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 Business Intelligence Development Studio. 

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 SQL Server 2005 Integration Services (SSIS) packages, update connection strings to use the SQL Server 2008 names for the following providers:

  • Analysis Services OLE DB provider

  • SQL Server Native Client

The SSIS 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 Integration Services expression language, or by using code in a Script task.

Create new package ID

When upgrading SQL Server 2005 Integration Services (SSIS) packages, create new package IDs for the upgraded versions of the packages.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.