1. Launch the DTS Import & Export Wizard. %BR%

<img src="%ATTACHURLPATH%/part3_img1.png" style="wikiautogen"/> %BR%

2. Click the Next button. %BR%

 <img src="%ATTACHURLPATH%/part3_img2.png" style="wikiautogen"/> %BR%

3. Use the first Data Source dialog to configure a connection to SQL Server.%BR%

 <img src="%ATTACHURLPATH%/part3_img3.png" style="wikiautogen"/>%BR%

4. Use the Destination Drop-down to select the <nop>OpenLink OLE DB Provider for Virtuoso.%BR%

<img src="%ATTACHURLPATH%/part3_img5.png" style="wikiautogen"/>%BR%

5. Click the Properties button that appears.%BR%

<img src="%ATTACHURLPATH%/part3_img7.png" style="wikiautogen"/>%BR%

6. Use the Hostname field to pass the hostname and listen port of your Virtuoso instance.%BR%

<img src="%ATTACHURLPATH%/part3_img8.png" style="wikiautogen"/>%BR%

7. Use the User name and Password fields to provide your Virtuoso DBA authentication information. %BR%

<img src="%ATTACHURLPATH%/part3_img9.png" style="wikiautogen"/>%BR%

8. Use the "Select the database" drop down menu to select the Virtuoso VDB schema that will hold your linked in tables.%BR%

<img src="%ATTACHURLPATH%/part3_img10.png" style="wikiautogen"/>%BR%

9. Test your Destination Data Source configuration.%BR%

<img src="%ATTACHURLPATH%/part3_img11.png" style="wikiautogen"/>%BR%

10. Click Next.%BR%

<img src="%ATTACHURLPATH%/part3_img12.png" style="wikiautogen"/>%BR%

11. Click the Copy table(s) radio button.%BR%

<img src="%ATTACHURLPATH%/part3_img13.png" style="wikiautogen"/>%BR%

12. Scroll through the tables list box and check the table that you want to export.%BR%

<img src="%ATTACHURLPATH%/part3_img14.png" style="wikiautogen"/>%BR%

13. Check "Run immediately" and proceed to the next dialog.%BR%

<img src="%ATTACHURLPATH%/part3_img15.png" style="wikiautogen"/>%BR%

14. Click Finish. %BR%

<img src="%ATTACHURLPATH%/part3_img16.png" style="wikiautogen"/>%BR%

15. Wait for confirmation of table replication to occur.%BR%

<img src="%ATTACHURLPATH%/part3_img17.png" style="wikiautogen"/>%BR%

16. Click Done.%BR%

<img src="%ATTACHURLPATH%/part3_img18.png" style="wikiautogen"/>%BR%


Proceed to [[DTSExportViaVDBp4|Confirm Virtuoso Table Replication]]