What does Atlan crawl from SSIS

✦TL;DR

Review the SSIS asset types, metadata, and lineage Atlan extracts during crawling

||

|Connect

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