Microsoft SQL Server Integration Services (SSIS) connection

To access your data in Microsoft SQL Server Integration Services, create a connection asset for it.

Microsoft SQL Server Integration Services (SSIS) is a data integration platform.

Supported versions

Microsoft SQL Server Integration Services for Microsoft SQL Server 2022.

Create a connection to Microsoft SQL Server Integration Services

To create the connection asset, you need the following connection details:

Hostname or IP address
Port number
If the Microsoft SQL Server has been set up in a domain that uses NTLM (New Technology LAN Manager) authentication, select Use Active Directory. Then enter the name of the domain associated with the username and password
SSL certificate (if required by the database server)
Username and password

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Federal Information Processing Standards (FIPS) compliance

This connection cannot be created in a FIPS environment.

Microsoft SQL Server Integration Services setup

Install Integration Services (SSIS)

Restrictions

You can use this connection only for source data. You cannot write to data or export data with this connection.

Supported file types

The Microsoft SQL Server Integration Services connection supports importing ETL job information.