RE: Data Transfer b/w SQL Server 2005 and DB2 UDB.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Your IBM guy may like the ODBC method because it's easy for him, but just
realize that when you go to deploy this, you will need the same ODBC setup on
the server.

Also, SSIS does not interface with ODBC the same way it interfaces with the
same respective native provider pointing to the same source.

My suggestion: install the Microsoft OLE DB for DB2 Provider (you will need
Enterprise SQL, won't work with Standard) and do a side-by-side comparison.
Then YOU decide which to use. Don't let your DB2 DBA decide if his
involvement is one-time setup and your involvement is designing and
maintaining multitudes of SSIS packages.

HTH
=====
Todd C


"MZeeshan" wrote:

I am trying to setup a scheduled data transfer b/w SQL Server 2005 and IBM
DB2 UDB v9.5 (Unix/Sun Solaris). I am using the latest IBM ODBC drivers v9.7
(used earlier version v8.1 but same result).

The data transfer requirement will eventually be bi-directional although I
am currently testing data import into SQL Server from DB2. One of my
colleagues, a DB2 DBA, has helped me in setting up the ODBC DSN for DB2 and I
was able to find and select tables on the other end when trying to create a
SSIS package using import/export task feature.

That's where the problem is happening: Apart from some cases there is always
a data type mismatch with data types 131, 130, 137 etc. appearing for table
marked for data import.

Has anyone encountered such problem and what's the best way to resolve this
issue? I've also downloaded MSFT OLE DB driver for DB2, however, the DB2 DBA
found it much easier to setup DSN using the IBM client tools.

Thanks a bunch.

--
Regards,
MZeeshan
.

Relevant Pages

  • Re: Simple query executes fast but renders slow...
    ... So, ODBC, right? ... no database engine can perform ... I've spent a lot of time on a PC running Access Queries against a DB2 ...
    (microsoft.public.access.queries)
  • Re: Simple query executes fast but renders slow...
    ... Then I wrote queries and reports based on the local versions. ... So, ODBC, right? ... > I've spent a lot of time on a PC running Access Queries against a DB2 ...
    (microsoft.public.access.queries)
  • Re: sp_addlinkedserver for DB2
    ... If you have HIS, you can get the required ODBC ... drivers from the administration client .For DB2, ... Configuring Data Sources for the Microsoft OLE DB Provider for AS/400 ... Configuring Data Sources for the Microsoft OLE DB Provider for DB2' ...
    (microsoft.public.sqlserver.programming)
  • Re: Access to AS/400 data
    ... GS> Nicholas, why do you insist it must be done using ODBC? ... GS> database on _any_ machine from AIX is simply a matter of connecting to ... which the DB2 CLI API does very well. ...
    (comp.unix.aix)
  • Re: Note to Kate...
    ... Calling the IBM S&D team 'too thick'? ... Customers don't regret making their migration from one product to ... their SAP instance from Informix to DB2. ... SAP and convinced them *not* to support IDS... ...
    (comp.databases.informix)