Microsoft SQL Server Integration Services Sources > Before you begin > Create a connection
  

Create a connection

To connect using the SSISDB option, create a connection object in Administrator.
    1In Administrator, select Connections.
    2Click Add Connection.
    3Select SQL Server and click Next.
    4Enter the connection properties.
    The following table describes the connection properties:
    Property
    Description
    Runtime Environment
    The execution platform that runs tasks. The runtime environment is either a Secure Agent or a serverless runtime environment.
    User Name
    Name of the Microsoft SQL Server user account that connects to the Microsoft SQL Server database.
    Host
    Host name of the machine where Microsoft SQL Server runs.
    Port
    Port number for the Microsoft SQL Server database engine service.
    Code Page
    Code page associated with the Microsoft SQL Server database.
    Schema
    A list of schema for which you want to extract metadata.
    Database Name
    Name of the Microsoft SQL Server database to connect to.
    5Click Test to test your connection to the source system.
    6Click Save.