%META:TOPICPARENT{name="UDASystemIntegrationConfigDocs"}%
= Configure SSIS Import to use the <nop>OpenLink OLE DB Provider for ODBC Data Sources =

# Open the **Microsoft SQL Server Management Studio**.
# Expand the **Databases** folder.  
# Right click on the database in question.
# Select **Tasks**.
# Select **Import Data**.
# That will bring up the **Microsoft SQL Server Import / Export Wizard**.
# Click **Next**.
# In the data source select **<nop>OpenLink ODBC Provider**
# Click the **Properties** button.
# Tick the **Use data source name** radio button.
# Locate your **Data Source Name**.
# Use the **User name** and **Password** fields to provide authentication, if required.
# Click **OK**.
# Click **Next**.
# Use the **Destination** tab to specify the target Microsoft SQL Server.
# Click **Next**.
# Opt to select a query or tables to transfer.
# Cick **Next**. 
# Provide the relevant tables or query.    
# Click **Next**.
# Use the **Save** and **Execute Package** dialog to configure the package.
# Click **Next**.
# Click **Finish**.