Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

No tables or views could be loaded. Expand / Collapse
Author
Message
Posted Monday, December 22, 2008 11:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 1:19 PM
Points: 7, Visits: 95
In the OLE DB Source Editor, the drop down select list for "Name of the table or view" returns "No tables or views could be loaded."

The Test Connection succeeds in the connection manager for the DB2 data source.

I am creating this SSIS package to replace a DTS package that does show/load the list of tables from this data source.

Would greatly appreciate some assistance with this!
Post #624129
Posted Wednesday, September 21, 2011 10:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 2:33 PM
Points: 204, Visits: 467
+ 1
I've tried an OLEDB connection into Oracle, and also an ado.net connection to Oracle. The OLEDB connection crashes the table browser in the dataflow destination when I click on the tablename drop down box, the drop down box for the ado.net destination shows "no tables or views could be loaded"
Post #1179163
Posted Thursday, September 22, 2011 9:03 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 817, Visits: 1,646
A bit of an uglier fix maybe, but I've found for ADO.NET connections, you pretty much need to use the DataReader source instead of the OLE DB source.
Post #1179501
Posted Sunday, September 25, 2011 3:57 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 2:33 PM
Points: 204, Visits: 467
I'll give that a try but my instinct tells me that is not the issue - it seems to 'read' the first 9000-ish rows quickly, then takes an inordinate length of time to do the commit, its like its reading the buffer, then inserting and committing one row at a time. I'm not doing anything different to the way I would normally do it in sql server 2k5 or 2k8r2.
Post #1180685
Posted Monday, September 26, 2011 7:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 12:16 PM
Points: 3, Visits: 169
Is your DB2 data encrypted?
Post #1180971
Posted Monday, September 26, 2011 3:59 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 2:33 PM
Points: 204, Visits: 467
Its not DB2, its Oracle.

I am having some progress by moving to 2008R2 and using the Attunity oracle connector, but its still not 100% working.
Post #1181398
Posted Tuesday, April 23, 2013 7:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 2:18 PM
Points: 1, Visits: 3
Be sure to select both a database and a server.
Post #1445436
Posted Tuesday, April 23, 2013 3:04 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 2:33 PM
Points: 204, Visits: 467
Thanks, but you cannot get to a table list unless you have selected both a database and a server.
Even though this is two years old, I did end up working around this by using the attunity connector.
Post #1445691
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse