Skip to main content

Set up SQL Server Integration Services (SSIS)

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
    📦 ssis-files/
    ├── 📁 ProjectA/
    │   ├── 📄 ProjectA.dtproj
    │   ├── 📄 Package1.dtsx
    │   ├── 📄 Package2.dtsx
    │   └── 📄 ProjectA.conmgr
    └── 📁 ProjectB/
        ├── 📄 ProjectB.dtproj
        └── 📄 Package1.dtsx

    Each project folder contains the .dtproj file and all associated .dtsx package files. Include .conmgr files if your packages use Azure components.

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

Next steps​

  • Crawl SSIS assets: Create the workflow, configure Azure Blob Storage credentials, and run the crawl