MS SSIS Connection
This article describes how to connect to SQL Server Integration Services (SSIS) for lineage extraction.
See also MS SSIS Lineage Scanner.
Prerequisites
-
Review how sources and connections work.
-
Create a source to add this connection to.
-
SSIS 2012 or later is required. The connection targets the
SSISDBcatalog database on your SQL Server instance.
Add a connection
-
Go to [your source] > Connections and select Add Connection.
-
In Connection type, select SSIS.
-
Fill in the following:
-
Name: A meaningful name for your connection. Used to indicate the location of catalog items.
-
Description (Optional): A short description of the connection.
-
JDBC: A JDBC connection string pointing to the SQL Server instance that hosts the
SSISDBcatalog database. See JDBC connection string format.
-
Add credentials
| Only Username and password authentication is currently supported. |
The account used for metadata extraction needs specific permissions. See SSIS permissions.
-
Select Add Credentials.
-
Fill in the following:
-
Name: Provide a clear name for this set of credentials.
-
Description (Optional): Explain what the credentials are used for or provide other useful information.
-
Username: The username for the Dremio account.
-
Password: The password for the Dremio account.
-
-
To use this set of credentials by default when connecting to the data source, select Assign as default.
| Always use the dedicated credential fields for authentication details such as passwords, secrets, and tokens. This ensures credentials are handled with the appropriate level of protection and reliably preserved across environments. |
| One set of credentials must be defined as default for each connection. Otherwise, DQ evaluation fails and previewing data in the catalog is not possible. |
Was this page useful?