What does Atlan crawl from SSIS Review the SSIS asset types, metadata, and lineage Atlan extracts during crawling
| | Your AI can read this via Docs MCP curl -fsSL "https://docs.atlan.com/install-docs-mcp" | bash ⎘ 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