SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


No tables or views could be loaded.


No tables or views could be loaded.

Author
Message
Mary Kundrath
Mary Kundrath
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 129
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!
niall.baird
niall.baird
SSC Eights!
SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)

Group: General Forum Members
Points: 816 Visits: 484
+ 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"
kramaswamy
kramaswamy
SSCarpal Tunnel
SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)

Group: General Forum Members
Points: 4006 Visits: 1832
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.
niall.baird
niall.baird
SSC Eights!
SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)

Group: General Forum Members
Points: 816 Visits: 484
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.
SAMY BAIG
SAMY BAIG
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 178
Is your DB2 data encrypted?
niall.baird
niall.baird
SSC Eights!
SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)

Group: General Forum Members
Points: 816 Visits: 484
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.
sam.horton
sam.horton
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 3
Be sure to select both a database and a server.
niall.baird
niall.baird
SSC Eights!
SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)SSC Eights! (816 reputation)

Group: General Forum Members
Points: 816 Visits: 484
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search