SQL 2012 Import and Export Wizard

Question

question

tstrole asked May 19, '15

SQL 2012 Import and Export Wizard

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

ssdt db2-provider

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@SQLShark commented · May 19, 2015 at 07:21 PM

Do you have permissions to these tables in DB2? Can you connect and run queries against them?

0 ·

tstrole commented · May 19, 2015 at 07:24 PM

Yes I do..

0 ·

Answer 1 · 2015-05-21T15:04:09Z

nidheesh.r.pillai answered May 21, '15

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.

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai commented · May 22, 2015 at 02:56 PM

Ok great! So, if your curiosity is indeed satisfied, do up-vote the answer and click the tick-mark, thereby accepting it. Happy to help!

3 ·

tstrole commented · May 21, 2015 at 03:17 PM

Thank you. I can use the sql statement option within the OLE DB Source Editor and get to the table data that way, so I have a solution; I just was really curios why this is the only access method, and the list of tables will not display.

1 ·

question