64 Bit drivers IBM Db2

Hey guys .. I am trying to run SSIS on the WIn2k3 .. The server is a 64 bit machine. I could not find Db2 drivers for a 64 bit one .. any clues as to how , I can find it. By the way .. I have been running the package in 32 bit mode for now .. which I dont think is a very good idea.

Any suggestions are most welcome ..

Have you tried the Microsoft one (http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)

The standalone Microsoft OLE DB Provider 2005, which ships in the Feature Pack for SQL Server 2005, offers a single download package and setup program. The setup will detect the processor and install (1) X86 only on Windows X86, (2) x86 side-by-side X64 on Windows X64, or (3) x86 only on Windows IA64. The other Microsoft OLE DB Provider for DB2 that ships in HIS 2006, offers x86 only. The end result of running "either" setup program is an X86 only DB2OLEDB provider.

If you don't want the WOW64 "work-around" for SSIS, you must get the 64 bit provider for DB2 from IBM. Its part of their standard client install kit.

400 Linked Server to SQL Server via IBMDA400

I am running V5R2 on client and am trying to link a 400 from SQL Server
2000.
Can this be done using IBMDA400?
I have gotten to a point with the IBM DB2 UDB that I can connect without
error. But now I can't see my tables.
This is what I am using for my provider string:
User ID=USERNAME;Password=PASSWORD;Initial Catalog=DATABASE_NAME;Data
Source=AS_400_SERVER_NAME
I have also checked the In Process checkbox that some have talked about
needing to be checked.
Any assistance is appreciated.
Thanks,
JasonHi,
I had the the same problem for a time, and I don't want to check all the NG
you have crossposted to, so I don't know if you already had an answer, but
here it is anyway :
Add "Catalog Library List=Lib1 Lib2 Lib3" in the connect string where "Lib1
Lib2 Lib3" is the list of your iseries library you want to browse the tables
and views. The list can be space separated or coma separated.
HTH
Christophe Niel
Remove 'nospam' to mail me.
"Jason Penner" <pennerjason@.hotmail.com> a crit dans le message de
news:%23SqrM%23A8DHA.2028@.TK2MSFTNGP10.phx.gbl...
> I am running V5R2 on client and am trying to link a 400 from SQL Server
> 2000.
> Can this be done using IBMDA400?
> I have gotten to a point with the IBM DB2 UDB that I can connect without
> error. But now I can't see my tables.
> This is what I am using for my provider string:
> User ID=USERNAME;Password=PASSWORD;Initial Catalog=DATABASE_NAME;Data
> Source=AS_400_SERVER_NAME
> I have also checked the In Process checkbox that some have talked about
> needing to be checked.
> Any assistance is appreciated.
> Thanks,
> Jason
>