Data Migration & Integration Configuration
Configure SSIS Import using the OpenLink 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 :
- OpenLink ODBC Provider
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 SQL Server DBMS.
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.
