I'm running SQL Server 2012 and the Import and Export Wizard. I connect to IBM data source. When the Select Source Tables and Views dialog box opens, it states "The source database you have selected contains no visible tables or views. This happens when I use the IBM DB2 for iBMDASQL OLE DB Provider as well as the IBM DB2 for i IBMDA400 OLD DB Provider. What is required to make the user tables and views visible? Tammy
Hi, If the providers in question do not help, then you can try the other providers like **Microsoft OLE DB Provider for DB2** (enterprise edition only). If not, the last scope is the ODBC, but please be warned that ODBC can tend to be very slow. Let us know where you stand.