|
||||||||
|
||||||||
| Vendor | Microsoft |
| Tool Name | SQL Server Integration Services (SSIS) via DTSX |
| Tool Version | 9.0(2005) |
| Tool Web Site | http://msdn2.microsoft.com/en-us/library/ms141026.aspx |
| Supported Methodology | [Data Integration] ETL (Source and Target Data Stores, Transformations, Expression Conversion) via DTSX XML File |
Import tool: Microsoft SQL Server Integration Services (SSIS) via DTSX 9.0(2005) (http://msdn2.microsoft.com/en-us/library/ms141026.aspx)
Import interface: [Data Integration] ETL (Source and Target Data Stores, Transformations, Expression Conversion) via DTSX XML File from Import bridge: 'MicrosoftSqlServerIs' 6.0.3 - Nov 12 2008 19:28:37
| Parameter Name | Description | Type | Values | Default | Mandatory |
| File | Input file name. | FILE | *.dtsx | Yes | |
| 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 | *.txt *.ini *.properties |
| 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 Fri, 14 Nov 2008 20:26:26