# Microsoft SQL Server Integration Services (SSIS)

The Microsoft SSIS connector is used to connect data sources and transformations on field level found within SSIS packages. This can be both how they are used internally within the connector, as well as externally to data from other connectors in the NodeGraph container. This connector is currently in Preview state.

Package Deployment Model

There are two kinds of deployment model:

* Project Deployment Model

  When a project, containing packages and parameters, is deployed to the SSISDB catalog on an instance of SQL Server. Default deployment model since MS SQL Server 2012.

* Directory

  When projects and packages are not accessible from the server of deployment, a directory holding either entire projects (\*.Ispac) or separate packages (\*.Dtsx) can be used.

Information noteNote: There is also Legacy Project Deployment Model (Not supported). This is the default deployment model before MS SQL Server 2012.

Connection string:

Required when using Project Deployment Model. This is the connection string used to connect to the MS SQL Server where the projects are deployed. Use integrated security only if the NodeGraph service account has sufficient permissions. User needs to be member of either 'ssis\_admin' on SSISDB or have the role 'sysadmin'.

Project/Package Storage Path:

Required when using Directory Deployment Model. All project files (\*.Ispac) and separate package files (\*.Dtsx) found in directory, or any of its subdirectories, will be included.

Test: Depending on Deployment Model the test will do one of the following:

* When using Project Deployment Model, a control of the connection string is performed and verifies the ability to connect to SSIS on MS SWL Server to read and extract projects and packages.

Project Deployment Model Test status

Project Deployment Model Test status

Project Deployment Model Test status ![The status of items in the Project Deployment Model.](https://help.qlik.com/en-US/nodegraph/Content/Resources/Images/NodeGraph/ui-NodeGraphTD-24.png)

* When using Directory, a control is performed to ensure read access to path specified.

Figure 25 - Directory test status

Figure 25 - Directory test status

Figure 25 - Directory test status ![The status of items in the Directory.](https://help.qlik.com/en-US/nodegraph/Content/Resources/Images/NodeGraph/ui-NodeGraphTD-25.png)

[](https://help.qlik.com/en-US/nodegraph/Content/NodeGraph/Documentation/Using_NodeGraph/NodeGraph_Connectors/Microsoft_SSIS.htm)

#### Full list of connector fields

Add an SSIS connector

| Field | Default Input |
| --- | --- |
| SYSTEM ID | Id |
| SYSTEM NAME | Name |
| DESCRIPTION | Description (optional) |
| CONNECTOR TAGS | Tag1; Tag2; ... |
| DEPLOYMENT MODEL | Select category |
| CONNECTION STRING | data source=localhost; initial catalog=AdventureWorks;Integrated Security=SSPI; |
| SERVER NAME | mssql01-prod |
| FULLY QUALIFIED DOMAIN NAME | mssql01-prod.company.com |
| IP | 123.456.789.123 |
| DNS NAME | mssql01-prod.company.com;mssql02-prod.company.com; |