## What does Atlan crawl from SSIS

URL: https://docs.atlan.com/apps/connectors/etl-tools/ssis/references/what-does-atlan-crawl-from-ssis

> Review the SSIS asset types and metadata Atlan extracts during crawling

Atlan extracts metadata from SQL Server Integration Services (SSIS) project files to catalog SSIS assets.

## Project

| Source property | Atlan property |
|---|---|
| id | projectId |
| name | projectName |
| Description | Description |
| CreationDate | CreationDate |
| CreatorName | CreatorName |
| PackageName | packageName |
| PackageID | packageId |

## Package

| Source property | Atlan property |
|---|---|
| Id | id |
| name | name |
| description | description |
| CreationDate | creationDate |
| CreatorName | CreatorName |
| ProjectID | projectId |
| ProjectName | projectName |

## Control reusable unit

| Source property | Atlan property |
|---|---|
| Calculated | id |
| Calculated | name |
| Calculated | type |
| PackageID | parentPackageId |
| Calculated | packageCount |
| Calculated | taskCount |

## Control flow

| Source property | Atlan property |
|---|---|
| Id | id |
| name | name |
| type | type |
| packageId | packageId |
| packageName | packageName |
| ProjectID | projectId |
| ProjectName | projectName |
| DTS:From | inputControlFlowId |
| DTS:To | outputControlFlowId |

## Container reusable unit

| Source property | Atlan property |
|---|---|
| Calculated | id |
| Calculated | name |
| Calculated | type |
| ProjectID | projectId |
| ProjectName | projectName |
| ID | parentContainerTaskId |
| Calculated | ContaineTaskCount |
| Calculated | taskCount |

## Container

| Source property | Atlan property |
|---|---|
| Id | id |
| name | name |
| type | type |
| Description | description |
| packageId | packageId |
| packageName | packageName |
| ProjectID | projectId |
| ProjectName | projectName |

## Container flow

| Source property | Atlan property |
|---|---|
| Id | id |
| name | name |
| type | type |
| packageId | packageId |
| packageName | packageName |
| ProjectID | projectId |
| ProjectName | projectName |
| DTS:StartID | inputControlFlowId |
| DTS:EndID | outputControlFlowId |
| ContainerID | containerId |
| ContainerName | containerName |

## Data reusable unit

| Source property | Atlan property |
|---|---|
| Calculated | id |
| Calculated | name |
| Calculated | type |
| ProjectID | projectId |
| ProjectName | projectName |
| ID | parentTaskId |
| Calculated | DataTaskCount |
| Calculated | ComponentCount |

## Data flow

| Source property | Atlan property |
|---|---|
| Id | id |
| name | name |
| type | type |
| packageId | packageId |
| packageName | packageName |
| ProjectID | projectId |
| ProjectName | projectName |
| DTS:StartID | inputControlFlowId |
| DTS:EndID | outputControlFlowId |
| ContainerID | containerId |
| ContainerName | containerName |
| TaskID | taskId |
| TaskName | taskName |

## Task

| Source property | Atlan property |
|---|---|
| Id | id |
| name | name |
| type | type |
| packageId | packageId |
| packageName | packageName |
| ProjectID | projectId |
| SQLTask:SqlStatementSource | expression |

## Component

| Source property | Atlan property |
|---|---|
| Id | id |
| name | name |
| type | transformationType |
| Description | description |
| packageId | packageId |
| packageName | packageName |
| ProjectID | projectId |
| ProjectName | projectName |
| Calculated | transformationFieldCount |
| Calculated | querySQL |
| ContainerID | containerId |
| ContainerName | containerName |
| TaskID | taskId |
| TaskName | taskName |

## Component field

| Source property | Atlan property |
|---|---|
| Id | id |
| name | name |
| type | type |
| DataType | dataType |
| packageId | packageId |
| packageName | packageName |
| ProjectID | projectId |
| ProjectName | projectName |
| componentId | componentId |
| ComponentName | componentName |
| ContainerID | containerId |
| ContainerName | containerName |
| TaskID | taskId |
| TaskName | taskName |

## See also

* [Crawl SSIS assets](https://docs.atlan.com/llms/connectors/ssis/crawl-ssis/llms.txt): Configure and run the workflow to discover and catalog SSIS assets
* [Set up SSIS](https://docs.atlan.com/llms/connectors/ssis/set-up-ssis/llms.txt): Configure Azure Blob Storage and upload SSIS project files
* [Limitations and supported assets](https://docs.atlan.com/llms/connectors/ssis/limitations-and-supported-assets/llms.txt): Review limitations and supported asset types for the SSIS connector

---