Connectivity in between SQL Server and DB2

I would like to know whether a connection can established in between SQL
Server and DB2. If yes how?Hi!!
This may help you(Pls note that I have not tested this)
http://groups.google.com/group/micr...b72d654e19e7a51
and
http://support.microsoft.com/kb/q222937/
--
Thanks,
Umesh
"VBB" wrote:

> I would like to know whether a connection can established in between SQL
> Server and DB2. If yes how?
>

Connectivity from Non Sql Servers

How would I configure a DB2, SAP Or Teradata as source in SSIS

How do you usually connect to them? If you have an ODBC driver then you should be able to do it.

I dare say there are issues aorund this but having never connected to these systems I can't tell you more than that. there are people on here that HAVE connected to these systems.

-Jamie

|||

Hi Jamie,

Thanks for the quick response, but base product of Sql Server 2k5 does not have these odbc drivers. Does microsoft provides these or we need to purchase these drivers.

Thanks

Dharmbir

|||

I have no idea. My guess is you will have to buy them.

-Jamie

|||MS provides a OLE DB driver for DB2. You can find it on the following page.

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

As far as SAP goes, that depends on the underlying DB. If it runs

on Oracle, then MS offers a OLE DB driver, or you can download ODP.Net

from Oracle directly. If it runs on their SAPDB, which was handed

over to MySQL AB, then you should be able to find a OLEDB driver from www.mysql.com. MySQL rebranded the DB as MaxDB.

As far as Teradata goes, I've never worked with it so I can't be much help.

Larry Popesqlsql

Connection to oracle / sqlserver / db2 databases

Hi All,

Is there a way in SSIS to change the database connection to sqlserver or oracle or db2 without choosing the connection manager in the source.

For e.g. I ran a package which is reading data from sqlserver and later i want to connect to oracle to read the data but without changing the connection manager in the source.

Basically, i want to find out from you gurus is about a way to switch between databases without changing the connection managers. OR the only way is to make different sets of packages for oracle / db2 and sqlserver sources ?

Thanks,

Vipul

Vipul123 wrote:

Hi All,

Is there a way in SSIS to change the database connection to sqlserver or oracle or db2 without choosing the connection manager in the source.

For e.g. I ran a package which is reading data from sqlserver and later i want to connect to oracle to read the data but without changing the connection manager in the source.

Basically, i want to find out from you gurus is about a way to switch between databases without changing the connection managers. OR the only way is to make different sets of packages for oracle / db2 and sqlserver sources ?

Thanks,

Vipul

You could use a configuration and change it in there. Judging by another post of yours you have already done this hence, could you lock this thread? If you don't have permission to lock the thread, let me know. I will be able to do it.

-Jamie

|||

Jamie,

Please lock the thread as i dont have the permisssion to do it.

Thanks,

Vipul