dbTalk Databases Forums  

MS OLE DB Provider for DB2 and SSIS. Help Needed.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss MS OLE DB Provider for DB2 and SSIS. Help Needed. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Simon P
 
Posts: n/a

Default 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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.