To test ODBC connections to the data source databases:
On the Windows desktop, select Start, then Settings, then Control Panel to open the Control Panel window.
In the Control Panel window, double-click the Administrative Tools icon, and then double-click the Data Sources (ODBC) icon.
In the ODBC Data Source Administrator dialog box, click the System DSN tab.
In the System Data Sources list, select the data source created for OLAP Metadata Catalog or the data source database, and click Configure.
A data source configuration dialog box is displayed. Depending on the data source and the driver that you are using, you may be asked to log on to the database immediately, or you may be asked to review all the settings before testing the connection. In either case, after attempting to log on to the database, observe the resulting message boxes to determine if you connected to the data source successfully.
If you cannot connect to the database, check the Integration Server name, database name, user name, and password information for accuracy, and make sure that you are using the correct ODBC driver for the data source.
After you have successfully completed the preceding steps, try connecting to the data source from Integration Services Console.
See Testing the Integration Services Console Connection to the Data Source.
If the connection from Integration Services Console fails, proceed to Testing the Integration Server Connection to the Data Source.