SSIS not showing list of tables in either ADO.NET Source/Des

Posted by stoned99 on 01-Mar-2018 18:18

This is driving me nuts.

I can create a connection and test the connectivity using the .NET Provider Data Direct DB2 Data Provider for DB2 Z/OS but I cannot make SSIS display the list of tables or views. It just comes back with No Tables or views could be loaded.

When I create the connection I only enter user/password/database name/Host and Port

I'm using Connect for ADO.Net 4.2

Anybody have any advice ?

All Replies

Posted by Avadhoot Kulkarni on 04-Mar-2018 18:54
Hi,
 
We are setting up the environment to try it out to see what possible issues you might be encountering.
 
 
Thanks and Regards,
Avadhoot
 
 
Posted by Avadhoot Kulkarni on 05-Mar-2018 08:08

Hi,

I also found a thread with similar issue you faced a year and half back.  Just check if that provides you some pointers.

community.progress.com/.../28132

If that does not solve the problem, please let us know the visual studio version and BIDS version installed apart from the rest of the information I have asked in previous update.

Regards,

Avadhoot

This thread is closed