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 ?
Thanks and Regards,
Lead Principal Software Engineer
Progress Software Development Private Ltd.
I also found a thread with similar issue you faced a year and half back. Just check if that provides you some pointers.
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.