Jaa

Select Configuration Type (Package Configuration Wizard)

  • Artikkeli

Use the Select Configuration Type page to specify the type of configuration to create.

If you need additional information to determine which type of configuration to use, see Package Configurations.

Static Options

  • Configuration type
    Select the type of source in which to store the configuration, using the following options:

    Value Description

    XML configuration file

    Store the configuration as an XML file. Selecting this value displays the dynamic options in the section, Configuration Type.

    Environment variable

    Store the configuration in one of the environment variables. Selecting this value displays the dynamic options in the section, Configuration Type.

    Registry entry

    Store the configuration in the registry. Selecting this value displays the dynamic options in the section, Configuration Type.

    Parent package variable

    Store the configuration as a variable in the package that contains the task. Selecting this value displays the dynamic options in the section, Configuration Type.

    SQL Server

    Store the configuration in a table in SQL Server. Selecting this value displays the dynamic options in the section, Configuration Type.
  • Next
    View the next page in the wizard sequence.

Dynamic Options

Configuration Type Option = XML Configuration File

  • Specify configuration settings directly
    Use to specify settings directly.

    Value Description

    Configuration file name

    Type the path of the configuration file that the wizard generates.

    Browse

    Use the Select Configuration File Location dialog box to specify the path of the configuration file that the wizard generates. If the file does not exist, it is created by the wizard.

  • Configuration location is stored in an environment variable
    Use to specify the environment variable in which to store the configuration.

    Value Description

    Environment variable

    Select an environment variable from the list.

Configuration Type Option = Environment Variable

  • Environment variable
    Select the environment variable that contains the configuration information.

Configuration Type Option = Registry Entry

  • Specify configuration settings directly
    Use to specify settings directly.

    Value Description

    Registry entry

    Type the registry key that contains the configuration information. The format is <registry key>.

    The registry key must already exist in HKEY_CURRENT_USER and have a value named Value. The value can be a DWORD or a string.

    If you want to use a registry key is not at the root of HKEY_CURRENT_USER, use the format <registry key\registry key\...> to identify the key.

  • Configuration location is stored in an environment variable
    Use to specify the environment variable to store the configuration in.

    Value Description

    Environment variable

    Select an environment variable from the list.

Configuration Type Option = Parent Package Variable

  • Specify configuration settings directly
    Use to specify settings directly.

    Value Description

    Parent variable

    Specify the variable in the parent package that contains the configuration information.

  • Configuration location is stored in an environment variable
    Use to specify the environment variable that stores the configuration.

    Value Description

    Environment variable

    Select an environment variable from the list.

Configuration Type Options = SQL Server

  • Specify configuration settings directly
    Use to specify settings directly.

    Value Description

    Connection

    Select a connection from the list, or click New to create a new connection.

    Configuration table

    Select an existing table, or click New to write a SQL statement that creates a new table.

    Configuration filter

    Select an existing configuration name or type a new name.

    Many SQL Server configurations can be stored in the same table, and each configuration can include multiple configuration items.

    This user-defined value is stored in the table to identify configuration items that belong to a particular configuration

  • Configuration location is stored in an environment variable
    Use to specify the environment variable where the configuration is stored.

    Value Description

    Environment variable

    Select an environment variable from the list.

See Also

Other Resources

Package Configurations
Creating Package Configurations

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

14 April 2006
New content:
  • Added information about using registry entries to store configurations.

5 December 2005
New content:
  • Added explanation of configuration filters.