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
We are setting up the environment to try it out to see what possible issues you might be encountering.
Thanks and Regards,
Posted by Avadhoot Kulkarni on 05-Mar-2018 08:08


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.



This thread is closed