December 22, 2008 at 11:29 am
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!
September 21, 2011 at 10:47 pm
+ 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"
September 22, 2011 at 9:03 am
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.
September 25, 2011 at 3:57 pm
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.
September 26, 2011 at 7:38 am
Is your DB2 data encrypted?
September 26, 2011 at 3:59 pm
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.
April 23, 2013 at 7:55 am
Be sure to select both a database and a server.
April 23, 2013 at 3:04 pm
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.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply