## Task and crawl issues

URL: https://docs.atlan.com/apps/connectors/etl-tools/ssis/troubleshooting/task-and-crawl-issues

> Resolve authentication failures and common workflow errors for the SSIS connector

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

::::danger 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

::::danger 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

::::danger 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](https://docs.atlan.com/llms/connectors/ssis/set-up-ssis/llms.txt).

---

## See also

* [Set up SSIS](https://docs.atlan.com/llms/connectors/ssis/set-up-ssis/llms.txt): Configure Azure Blob Storage and upload SSIS project files
* [Crawl SSIS assets](https://docs.atlan.com/llms/connectors/ssis/crawl-ssis/llms.txt): Create the workflow and run the crawl

## Need help

If you need assistance after trying the steps, contact Atlan support by [submitting a request](https://docs.atlan.com/support/submit-request).

---