Skip to main content

Task and crawl issues

Use these steps to resolve common authentication failures, missing file errors, and path-related issues when running the SQL Server Integration Services (SSIS) Connector workflow in Atlan.

Authentication failure​

Error

Authentication failed or Unable to authenticate with Azure Blob Storage

Cause​

The workflow fails during authentication when Azure credentials are incorrect, missing, or the service principal lacks required permissions.

Solution​

  1. Verify these values in the workflow configuration match your Azure setup:
    • Azure Tenant ID
    • Client ID
    • Client Secret
    • Storage Account Name
    • Container Name
  2. Confirm the service principal has the Storage Blob Data Reader role on the storage account.
  3. Test authentication using the Test Authentication button in the workflow configuration to verify credentials and access.

Missing files in blob storage​

Error

Required files not found or Workflow fails after starting the crawl

Cause​

The workflow fails after starting the crawl when the Azure Blob container doesn't include all required files for each SSIS project folder.

Solution​

  1. Confirm the Azure Blob container includes the required files for each SSIS project folder:
    • .dtproj (project file)
    • .dtsx (package files)
  2. For projects that include Azure components, also include the .conmgr file (connection manager file).
  3. Verify all files are uploaded successfully by checking the container contents in the Azure portal.

Incorrect file or folder paths​

Error

Files not found or Workflow fails because the connector can't locate expected files

Cause​

The workflow fails because the connector can't locate expected files when file names or folder structure don't match the required SSIS folder structure.

Solution​

  1. Confirm the file names and folder structure match the required SSIS folder structure.
  2. Confirm each project folder contains the .dtproj file and all associated .dtsx package files.
  3. Verify folder structure matches the pattern shown in Set up SSIS.

See also​

Need help​

If you need assistance after trying the steps, contact Atlan support by submitting a request.