## Set up SQL Server Integration Services (SSIS)

URL: https://docs.atlan.com/apps/connectors/etl-tools/ssis/how-tos/set-up-ssis

> Configure Azure Blob Storage and upload SQL Server Integration Services (SSIS) project files for the SSIS Connector workflow

Configure Azure Blob Storage and upload your SQL Server Integration Services (SSIS) project files using the required folder structure. The SSIS connector reads metadata directly from these files during workflow execution.

## Prerequisites

Before you begin, make sure you have:

* Access to the Azure portal with permissions to create and configure Storage Accounts
* SSIS project files ready for upload, including:
 * `.dtproj` files (project files)
 * `.dtsx` files (package files)
 * `.conmgr` files (connection manager files, if your packages use Azure components)

## Create storage account

Create an Azure Storage Account configured for the SSIS connector workflow.

1. In the Azure portal, search for **Storage accounts** in the search bar.
2. Select **Create** to start the storage account creation wizard.
3. On the **Basics** tab, provide these details:
 * **Subscription**: Select your active Azure subscription
 * **Resource Group**: Create a new resource group or select an existing one
 * **Storage account name**: Enter a globally unique name (3-24 characters, lowercase letters and numbers)
 * **Region**: Select the region nearest to your SSIS files or Atlan instance
 * **Performance**: Select **Standard**
 * **Account kind**: Select **StorageV2 (General Purpose v2)**
4. Select **Review + Create** to validate your configuration.
5. After validation passes, select **Create** to provision the storage account.

 The deployment may take a few minutes. You'll see a notification when the storage account is ready.

## Configure storage account settings

After the storage account is created, configure security settings required for the SSIS connector.

1. Open your newly created Storage Account from the Azure portal.
2. In the left navigation, go to **Configuration** under **Settings**.
3. Configure these security settings:
 * **Secure transfer required**: Set to **Enabled**
 * **Minimum TLS version**: Select **Version 1.2** or higher
 * **Allow Blob anonymous access**: Set to **Disabled**
 * **Allow storage account key access**: Set to **Enabled**

## Create blob container

Create a container in your storage account to store SSIS project files.

1. In your Storage Account, go to **Data storage** → **Containers** in the left navigation.
2. Select **+ Container** to create a new container.
3. In the **New container** dialog, enter these values:
 * **Name**: Enter a descriptive name, for example `ssis-files`
 * **Public access level**: Select **Private (no anonymous access)**
4. Select **Create** to create the container.

 The container appears in your containers list.

## Upload SSIS project files

Upload your SSIS project files to the blob container using the required folder structure. The connector requires this structure to successfully extract metadata.

1. Open your blob container from the **Containers** list.
2. Create one folder per SSIS project inside the container. Each project folder contains all files for that specific SSIS project.
3. Upload these files into each project folder:
 * **`.dtproj`**: The SSIS project file that defines the project structure
 * **`.dtsx`**: Package files that contain the SSIS package definitions
 * **`.conmgr`**: Connection manager files (only required if your SSIS packages include Azure tasks or components)

 > *Folder structure example — see full content on the documentation site.*

4. Verify all files are uploaded successfully by checking the container contents in the Azure portal.

## Next steps

* [Crawl SSIS assets](https://docs.atlan.com/llms/connectors/ssis/crawl-ssis/llms.txt): Create the workflow, configure Azure Blob Storage credentials, and run the crawl

---