Data Migration & Integration Configuration

Configure MIcrosoft SQL Server DTS Import using the Microsoft OLE DB Provider

Use the following instructions to configure a DTS Import.

1. Open your Microsoft SQL Server Enterprise Manager.

2. Expand the following Tree Structure:

Console Root=>Microsoft SQL Servers=>SQL Server Group=>Your Actual SQLServer

3. Expand the Security folder.

4. Right click on Linked Servers.

5. Select "New Linked Server."

6. Supply the following information on your General tab:

• Linked Server: Any descriptive name (no spaces)
  
  
• (Check the "Other Data Source" radio buton)
  
  
• Provider Name: Microsoft OLE DB Provider for ODBC Drivers
  
  
• Product Name: MSDASQL
  
  
• Data Source: Your Multi-Tier Data Source Name
  
  
  

7. Do not check any server options on the bottom of the tab.

8. Provide your Data Source username and password on the Security tab.

9. Click OK to create your server.

10. Exit the Linked Server dialog box.

11. Locate your newly created Linked Server.

12. Expand the new Linked Server's tree menu.

13. Click the Tables icon.

14. Locate the qabasics table in the tables listbox.

15. Carefully record the Schema and Catalog associated with the table. For example:

Name	Schema	Catalog	Type
qabasics	dbo	master	User

16. Expand the Microsoft SQL Server Enterprise Manager's Tools menu.

17. Select the Microsoft SQLServer Query Analyzer.

18. Build your query using the following guidelines:

		
select * from [your linked server name].[catalog].[schema].qabasics 

For example:

select * from SQL2KLA.master.dbo.qabasics 

Note: Leave blanks in place holders when database lacks catalog or schema information. For example:

select * from ORA9iLA..SCOTT.qabasics 

19. Click the green arrow icon to run your query.