I am trying to create my first IS project and want to move data from a table on an AS400 db2 to sqlserver. I created the connection using the ole db provider for AS400 DB2. When I put the name of the database in the initial catalog field and do a test connection it says it conected just fine. When I double click on the source and get the ole db source editor window I go to the name of the table or view combo box it says "No tables or views could be loaded". Now if I go back to the connection manager and put the name of the schema rather than the database name and do a test connection I get an error that says it is an invalid catalog.

I can connect to this machine from excel using the ODBC provider.

Thank you in advance.

Quinn