 |
|
|||||||
 |
   
|
|
||||||
|
|
|||||||
|
|
|
||||||
| Vendor | Microsoft |
| Tool Name | SQL Server Integration Services (SSIS) |
| Tool Version | 9.0 (2005) to 10.0 (2008) |
| Tool Web Site | http://msdn2.microsoft.com/en-us/library/ms141026.aspx |
| Supported Methodology | [Data Integration] 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.0 (2008) (http://msdn2.microsoft.com/en-us/library/ms141026.aspx)
Import interface: [Data Integration] ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion) via DTSX XML File from Import bridge: 'MicrosoftSqlServerIs' 6.1.0 - Mar 2 2010 19:13:20
| 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 |
|
|||||
| __Incremental harvesting date | If a date is set, only metadata created or updated since the date will be imported. Use the ISO 8601 date format: yyyy-MM-dd HH:mm:ss | DATE | Hidden |
| 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 | |
| Model | Package | |
| Transformation | Data flow Source, Destination or Transformation | |
| Description | Description | |
| Name | Name | |
| TransformationTask | Data Flow | |
| Description | Description | |
| Name | Name |
Last updated on Tue, 2 Mar 2010 19:24:14
