%META:TOPICPARENT{name="UDASystemIntegrationConfigDocs"}%	

= Configuring Microsoft SQL Server DTS Import using the Single-Tier "Lite" Edition OLE DB Provider for ODBC Data Sources =

Use the following instructions to configure a DTS Import.

# Open your **Microsoft SQL Server Enterprise Manager.**%BR%%BR%
# Drill down to **Console Root** >> **Microsoft SQL Servers** >> **SQL Server Group** >> **Your Actual SQL Server.**%BR%%BR%
# Expand the **Security** folder.%BR%%BR%
# Right click on **Linked Servers.**%BR%%BR%
# Select "**New Linked Server**."%BR%%BR%
# Supply the following information on your **General** tab:%BR%%BR%
#* **Linked Server**: Any descriptive name (no spaces)
#* (Check the "**Other Data Source**" radio button)
#* **Provider Name**: **{{{OpenLink ODBC Provider}}}**
#* **Product Name**: **{{{OpenLinkOLEDB}}}**
#* **Data Source**: Your Multi-Tier DSN%BR%%BR%
# Do not check any server options on the bottom of the tab.%BR%%BR%
# Provide your Data Source username and password on the Security tab.%BR%%BR%
# Click **OK** to create your server.%BR%%BR%
# Exit the Linked Server dialog box.%BR%%BR%
# Locate your newly created Linked Server.%BR%%BR%
# Expand the new Linked Server's tree menu.%BR%%BR%
# Click the **Tables** icon.%BR%%BR%
# Locate the **qabasics** table in the tables list.%BR%%BR%
# Carefully record the Schema and Catalog associated with the table. For example —
{{{
NAME       SCHEMA   CATALOG   TYPE
qabasics   dbo      master    User
}}}
# Expand the Microsoft SQL Server Enterprise Manager's **Tools** menu.%BR%%BR%
# Select the Microsoft SQL Server **Query Analyzer**.%BR%%BR%
# Build your query with four-part naming, along these lines:
{{{
SELECT * FROM [your linked server name].[catalog].[schema].qabasics 
}}}
For example:
{{{
SELECT * FROM SQL2KLA.master.dbo.qabasics 
}}}
Note: Leave blanks as place holders when your target database lacks CATALOG or SCHEMA information. For example:
{{{
SELECT * FROM ORA9iLA..SCOTT.qabasics 
}}}
#  Click the green arrow icon to run your query.