What does Atlan crawl from SSIS
Review the SSIS asset types, metadata, and lineage Atlan extracts during crawling
Atlan extracts metadata from Microsoft SQL Server Integration Services (SSIS) project files to catalog SSIS assets and build lineage.
Lineage
The SSIS connector calculates lineage at both table level and column level.
Atlan reads the source and target references in each data flow task in your packages. Every data flow becomes a process in Atlan that connects its sources to its targets, so a chain of packages resolves into a single traversable lineage graph.
Table-level lineage
Table-level lineage tracks data flow between source and target tables across your packages:
dbo.City + dbo.Master_product + dbo.Sales_data
→ [SSIS Data Flow Task] → dbo.city_wise_product_sales_data
dbo.Country + dbo.city_wise_product_sales_data
→ [SSIS Data Flow Task] → dbo.country_wise_ice_cream_sales
Column-level lineage
Column-level lineage tracks how individual columns move and transform through the components in each data flow — for example Derived Column, Lookup, Aggregate, Merge Join, Conditional Split, and Union All.
SqlServer.dbo.Sales_data.Revenue → [SSIS Data Flow Task] → SqlServer.dbo.city_wise_product_sales_data.revenue
SqlServer.dbo.Master_product.Product_Name → [SSIS Data Flow Task] → SqlServer.dbo.city_wise_product_sales_data.product_name
Cross-connector lineage
Because lineage is keyed on the tables and columns named in your package files, SSIS lineage joins your wider lineage graph wherever those same assets are cataloged by another connector — for example a Microsoft SQL Server source or a Snowflake target. Crawl those systems as well so each reference resolves to a cataloged asset.
For the full set of lineage constraints, see Limitations and supported 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: Configure and run the workflow to discover and catalog SSIS assets
- Set up SSIS: Configure Azure Blob Storage and upload SSIS project files
- Limitations and supported assets: Review limitations and supported asset types for the SSIS connector