What does Atlan crawl from SSIS
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