question

tstrole avatar image
tstrole asked

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
ssdtdb2-provider
2 comments
10 |1200

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

Do you have permissions to these tables in DB2? Can you connect and run queries against them?
0 Likes 0 ·
Yes I do..
0 Likes 0 ·

1 Answer

·
nidheesh.r.pillai avatar image
nidheesh.r.pillai answered
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 comments
10 |1200

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

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 Likes 3 ·
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 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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