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

Part II: Prepare & Test your ODBC Data Sources

1. Launch the ODBC Data Sources Administrator which usually resides in the Administrative Tools folder in the Control Panel. %BR%
2. Click the System Administrator tab.%BR%
3. Locate or create a native SQL Server Data Source Name that connects to your Source database.%BR%

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

4. Test your DSN.%BR%

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

5. Locate or create a Data Source Name that connects to your Source database.%BR%

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

6. Test your DSN.%BR%

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

7. Close the ODBC Data Sources Administrator.%BR%

Proceed to: [[DTSExportViaVDBp3|Part III:]]