# Microsoft SQL Server Integration Services (SSIS) (via DSV File) - Export

Availability-note[AWS](https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-aws)

AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com

## Bridge Requirements

This bridge:

* is only supported on Microsoft Windows.

## Bridge Specifications

| **Vendor** | **Microsoft** |
| --- | --- |
| **Tool Name** | **SQL Server Integration Services (SSIS)** |
| **Tool Version** | **9.0 (2005) to 16x (2022)** |
| **Tool Web Site** | https://docs.microsoft.com/en-us/sql/integration-services/ |
| **Supported Methodology** | [Data Integration] BI Design (RDBMS Source, Dimensional Target) via DSV XML File |

**SPECIFICATIONS**  
**Tool:** Microsoft / SQL Server Integration Services (SSIS) version 9.0 (2005) to 16x (2022) via DSV XML File  
See https://docs.microsoft.com/en-us/sql/integration-services/  
**Metadata:** [Data Integration] BI Design (RDBMS Source, Dimensional Target)  
**Component:** MicrosoftSqlServerDsvExport.MicrosoftSqlServerIntegrationServices version 12.0.0  
  
**OVERVIEW**  
Exports a model containing a single schema to a Data Source View (DSV) file. If the model contains multiple schemas, export the model as an SQL Server Integration Services Project.  
  
**REQUIREMENTS**  
n/a  
  
**FREQUENTLY ASKED QUESTIONS**  
n/a  
  
${BridgeLib.bridge\_spec\_common\_limitations\_header}  
  
**SUPPORT**   
Provide a troubleshooting package with debug log. Debug log can be set in the UI or in conf/conf.properties with MIR\_LOG\_LEVEL=6

## Bridge Parameters

| **Parameter Name** | **Description** | **Type** | **Values** | **Default** | **Scope** |
| --- | --- | --- | --- | --- | --- |
| **File** | Generates an XML file with extension '.dsv' representing a single schema.<br><br>Import this file into SSIS or SSAS by right-clicking your project and choosing Add&gt;Existing file. | FILE | \*.dsv |  | Mandatory |
| **DSV Name** | Specify the DSV name to be used in the generated file.<br><br>This name must be unique for each DSV file in a project.<br><br>If nothing is specified, a name is built from the catalog and schema names. | STRING |  |  |  |
| **XML Indentation (pretty printing)** | Controls the pretty printing of XML, for the purpose of opening the generated file in a text editor. E.g.<br><br><br><br>'space characters'<br><br>Several space characters as indentation.<br><br><br><br>'tab key'<br><br>Tab character as indentation.<br><br><br><br>'empty'<br><br>No indentation which leads to a more compact file. | STRING |  |  |  |

## Bridge Mapping

| **Meta Integration Repository (MIR)<br>Metamodel<br>(based on the OMG CWM standard)** | **"Microsoft SQL Server Integration Services (SSIS) (via DSV File)"<br>Metamodel<br>MicrosoftSqlServerDsv** | **Mapping Comments** |
| --- | --- | --- |
|  |  |  |
| **Association** |  | **The foreign key information is exported** |
| **AssociationRole** |  | **The foreign key information is exported** |
| **AssociationRoleNameMap** | **SourceField, TargetField** |  |
| DesignLevel |  | No equivalent for Logical Only objects. |
| **Attribute** | **Column** |  |
| Description | msprop:Description | Mapped only if comment is empty. |
| DesignLevel |  | No equivalent for Logical Only objects. |
| Name | msprop:FriendlyName | Attribute Name. Computed if not set |
| Optional | minOccurs |  |
| PhysicalName | msprop:DbColumnName | Attribute Physical Name.Computed from 'name' if not set |
| **BaseType** | **type** |  |
| DataType | Datatype | See datatype 'DataType Mapping' worksheet |
| DesignLevel |  | No equivalent for Logical Only objects. |
| Length | msdata:DataSize |  |
| **CandidateKey** | **xs:unique** |  |
| DesignLevel |  | No equivalent for Logical Only objects. |
| PhysicalName | name | Class Physical Name.Computed from the 'name' if not set |
| UniqueKey | msdata:PrimaryKey="true" |  |
| **Class** | **Table** |  |
| Description | msprop:Description |  |
| DesignLevel |  | No equivalent for Logical Only objects. |
| Name | msprop:FriendlyName | Class Name. Computed if not set |
| PhysicalName | msprop:DbTableName | Class Physical Name.Computed from the 'name' if not set |
| DesignLevel |  | No equivalent for Logical Only objects. |
| Name | xs:element.name |  |
| **DerivedType** | **type** |  |
| DataType | Datatype | See datatype 'DataType Mapping' worksheet |
| DesignLevel |  | No equivalent for Logical Only objects. |
| Length | msdata:DataSize |  |
| **ForeignKey** | **xs:keyref** |  |
| DesignLevel |  | No equivalent for Logical Only objects. |
| **Index** | **TargetIndex** |  |
| DesignLevel |  | No equivalent for Logical Only objects. |
| Generate |  | if set to false the index is not exported |
| PhysicalName | name | Class Physical Name.Computed from the 'name' if not set |
| **IndexMember** | **TargetIndexField** | **use linked attribute's name for the target index field name** |
| DesignLevel |  | No equivalent for Logical Only objects. |
| Position |  | position in XML file |
| **SQLViewAttribute** | **View Column** |  |
| Description | msprop:Description | Mapped only if comment is empty. |
| DesignLevel |  | No equivalent for Logical Only objects. |
| Name | msprop:FriendlyName | Attribute Name. Computed if not set |
| PhysicalName | msprop:DbColumnName | Attribute Physical Name.Computed from 'name' if not set |
| Position |  | The attributes are ordered by position in the XML file |
| **SQLViewEntity** | **View** | **Tables withTableType=View** |
| Description | msprop:Description |  |
| DesignLevel |  | No equivalent for Logical Only objects. |
| Name | msprop:FriendlyName | Class Name. Computed if not set |
| PhysicalName | msprop:DbTableName | Class Physical Name.Computed from the 'name' if not set |