Data Migration & Integration Configuration

Configure SSIS Import using the Microsoft OLE DB Provider

1. Open the Microsoft SQL Server Management Studio.
   
2. Expand the Databases folder.
   
3. Right click on the database in question.
   
4. Select Tasks.
   
5. Select Import Data.
   
6. That will bring up the Microsoft SQL Server Import / Export Wizard.
   
7. Click Next.
   
8. In the data source select Microsoft OLE DB provider for ODBC
   
9. Click the Properties button.
   
10. Tick the Use data source name radio button.
    
11. Locate your Data Source Name.
    
12. Use the User name and Password fields to provide authentication, if required.
    
13. Click OK.
    
14. Click Next.
    
15. Use the Destination tab to specify the target Microsoft SQL Server.
    
16. Click Next.
    
17. Opt to select a query or tables to transfer.
    
18. Cick Next.
    
19. Provide the relevant tables or query.
    
20. Click Next.
    
21. Use the Save and Execute Package dialog to configure the package.
    
22. Click Next.
    
23. Click Finish.