November 15, 2007 at 8:54 am
I'm trying to export data from a SQL Server 2005 database to a DB2 database through SSIS. However, I keep getting an error that says "Could not retrieve table list" with Invalid Conversion. SQLSTATE=07006. Does anybody have any ideas or what the problem could be? The replies so far that I have gotten have been...
-Kyle
-------------------------------
Where exactly do you get this error?
Thanks,
Bob
--------------------------------
I am getting the error on the SELECT source tables and views screen.
-Kyle
--------------------------------
What type of provider are you using for your sql sql server connection manager?
Does a 'test connection' succeed?
--------------------------------
It loks like fetching of table metadata does not work for your provider. Is there a way you could try to see that metadata in some other tool after setting the same connection parameters (DSV wizard in BIDS perhaps). Try to double-check your schema related connection settings.
HTH,
Bob
--------------------------------
The test connection does succeed. The provider I am using is the IBM OLE DB Provider for DB2
--------------------------------
Can you try using MS OLE DB for DB2 to see if you get the same error? Also, is there a blob column in the source/destination table? If there is, try to move the data without the blob column and see if you get this error.
-------------------------------- (Does anybody know what this is? I can't seem to find the MS OLE DB for DB2)
There are no blobs
November 15, 2007 at 9:38 am
Quick Google Search:
discussion of microsoft ole db provider for db2 with link to download...
http://blogs.msdn.com/dotnetinterop/archive/2006/01/19/oledb-provider-for-db2.aspx
---------------------------------
That doesn't work because the server that this is running from does not use one of the supported editions.
-Kyle
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply