SSIS not showing list of tables in either ADO.NET Source/Des - DataDirect Connect - Forum

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 ?

DataDirect Connect - Forum

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.

Is it the first time you are trying SSIS with Connect ADO.NET DB2 provider? or you had it working earlier but something went wrong this time?
Can you please share the visual Studio Activity Log (blogs.msdn.microsoft.com/.../) and ADO.NET Trace file (knowledgebase.progress.com/.../000009058) which will give us some idea on what is happening.

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