MS OLE DB Provider for DB2 and SSIS. Help Needed. -
03-09-2009
, 04:20 PM
HELP !
I am trying to get several developer workstations working with the follow
setup...
Windows XP (32-bit) SP2
SQL 2005 Developer - SP3
MS OLE DB for DB2 v2.0
I need to get the DB2 to connect to transfer tables in a SSIS package.
I am able to get the connections working and tested OK, and to 'build the
Packages' in the Data Source dialog boxes.
But when I try and to access the list of tables or preview the results of
simple SELECT statements in an OLE DB Datasource, I get an
error "Internal NetLib Error".
I have the same software, albeit 64-bit, and connection strings and SSIS
packages working fine, if I develop directly on the SQL server with remote
desktop, but this is not good practice.
Windows 2003 Enterprise Server 64-bit (x64)
SQL 2005 Enterprise (x64) - SP3
MS OLE DB for DB2 v2.0 (x64)
I have Google'd like crazy to try and sort this, but with no success for
about a week so far.
Any clues what I could be missing, or where interrogate the generic Internal
Netlib error in more detail ?
Any help greatly appreciated.
Simon P. |