SQL Server Management Connection

Declares a 'SqlServerManagementConnection' that targets the local SQL Server instance through SQL Server Management Objects (SMO). This connection type is used by management-oriented SSIS tasks such as Transfer Database, Transfer Logins, Transfer SQL Server Objects, Transfer Jobs, Transfer Master Stored Procedures, and Transfer Error Messages, rather than by data flow components. Change 'SqlServerName' to a remote host name or named instance ('SERVER\INSTANCE') to manage objects on a different server.

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <Connections>
    <SqlServerManagementConnection Name="SqlServerManagementConnection" SqlServerName="localhost" />
  </Connections>
</Biml>