 |
|
|||||||
 |
   
|
|
||||||
|
|
|||||||
|
|
|
||||||
 |
 |
 |
 |
|
 |
|
 |
 |
| Vendor | Microsoft |
| Tool Name | SQL Server Integration Services (SSIS) |
| Tool Version | 9.0 (2005) to 10.5 (2008 r2) |
| Tool Web Site | http://msdn2.microsoft.com/en-us/library/ms141026.aspx |
| Supported Methodology | [Data Integration] Multi-Model, ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion) via DTSX XML File |
Import tool: Microsoft SQL Server Integration Services (SSIS) 9.0 (2005) to 10.5 (2008 r2) (http://msdn2.microsoft.com/en-us/library/ms141026.aspx)
Import interface: [Data Integration] Multi-Model, ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion) via DTSX XML File from Import bridge: 'MicrosoftSqlServerIs' 7.0.4 - 2012-05-15 19:30:29
| Parameter Name | Description | Type | Values | Default | Scope | |||
| File | Input file name. | FILE | *.dtsx | Mandatory | ||||
| Variable values file | File defining list of DataStage variable values in format: variable1_name=variable1_value variable3_name=variable2_value ... variableN_name=variableN_value Typically variable names are starting with '$' sign if they are referring to environment variables. Variable names are case insensitive and trimmed of all leading and trailing spaces. If variable is found in the source metadata, but its value is not found in the file, bridge will try to use environment variables to resolve the value. If this parameter is empty, only the DOS environment variable values at execution time will be used. |
FILE |
|
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Microsoft SQL Server Integration Services (File)" Metamodel |
Mapping Comments |
| Attribute | Column | |
| Description | Column.Description | |
| Name | Column.Name | |
| BaseType | SSIS Type | |
| Class | Table | |
| Description | Table.Description | |
| Name | Table.Name | |
| ClassifierMap | Connection or Trainsformation Output link | |
| Description | Description | |
| Name | Name | |
| DataAttribute | Transformation Column | |
| Description | Description | |
| Name | Name | |
| DataSet | Output/Input | |
| Description | Description | |
| Name | Name | |
| DerivedType | ColumnType | |
| Name | DataType | |
| DesignPackage | Package | |
| Description | Package.Description | |
| Name | Package.Name | |
| FeatureMap | Input/Output column lineageId link | |
| Name | Name |
Last updated on Tue, 15 May 2012 19:39:08
