WMI Connection Manager

A WMI connection manager enables a package to use Windows Management Instrumentation (WMI) to manage information in an enterprise environment. The Web Service task that Microsoft SQL Server Integration Services includes uses a WMI connection manager.

When you add a WMI connection manager to a package, Integration Services creates a connection manager that that will resolve to a WMI connection at run time, sets the connection manager properties, and adds the connection manager to the Connections collection on the package. The ConnectionManagerType property of the connection manager is set to WMI.

Configuration of the WMI Connection Manager

You can configure a WMI connection manager in the following ways:

  • Specify the name of a server.

  • Specify a namespace on the server.

  • Select the authentication mode for connecting to the server.

    You can set properties through SSIS Designer or programmatically.

    For information about the properties that you can set in SSIS Designer, see WMI Connection Manager Editor.

    For information about configuring a connection manager programmatically, see ConnectionManager and Adding Connections Programmatically.

WMI Connection Manager Editor

Use the WMI Connection Manager dialog box to specify a Microsoft Windows Management Instrumentation (WMI) connection to a server.

To learn more about the WMI connection manager, see WMI Connection Manager.

Options

Name
Provide a unique name for the connection manager.

Description
Describe the connection manager. As a best practice, describe the connection manager in terms of its purpose, to make packages self-documenting and easier to maintain.

Server name
Provide the name of the server to which you want to make the WMI connection.

Namespace
Specify the WMI namespace.

Use Windows authentication
Select to use Windows Authentication. If you use Windows Authentication, you do not need to provide a user name or password for the connection.

User name
If you do not use Windows Authentication, you must provide a user name for the connection.

Password
If you do not use Windows Authentication, you must provide the password for the connection.

Test
Test the connection manager settings.

See Also

Web Service Task
Integration Services (SSIS) Connections