|
Home > Archive > MS SQL Server DTS > March 2006 > SSIS and DB2 Connection
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SSIS and DB2 Connection
|
|
| Guber 2006-03-21, 11:31 am |
| Hello All,
I'm trying to develop a simple SSIS Package which copies an entire table
from DB2 to SQL Server 2005.
I'm facing with some problems in the DB2 connection. I tried to use both IBM
OLEDB Connection and ODBC and did not had success.
I downloaded the Microsoft OLE DB Provider for DB2 but I did not have
success configuring the connection.
When I try to add a new Connection Manager I got the message:
Test connection failed because of an error in initializing the provider. -
The parameter is incorrect.
Is there any different way to connect to DB2 using a SSIS Package?
Could someone help me on this issue ?
Thank you,
Guber
| |
| Todd C 2006-03-27, 1:33 pm |
| Hello Guber.
We also use DB2 for one major business app. :(
Some things I did to get past the "parameter is incorrect" stage:
Make sure you visit ALL parts of the Data Source dialog. On the first
screen, I put in the static IP address of the DB2 box, the User name,
Password, and Initial Catalog. Under the Data Links button, I supplied the IP
address again in Data Source, User name, Password, Initial Catalog, and
Package collection. Then, in the Network section near the top, I selected
TCP/IP and click the elipsis (...) and supplied the IP address a third time.
Check to make sure the Initial Catalog, Package Collection, and Default
Schema settings are all correct. I had to check with my DB2 administrator for
that stuff. That was the kicker for me. I think that 'initial catalog' in DB2
lexicon is not the same as it is in other OLE DB sources. "Package
Collection" in DB2 refers to the database name.
Hope this helps.
Todd C
"Guber" wrote:
> Hello All,
>
> I'm trying to develop a simple SSIS Package which copies an entire table
> from DB2 to SQL Server 2005.
>
> I'm facing with some problems in the DB2 connection. I tried to use both IBM
> OLEDB Connection and ODBC and did not had success.
> I downloaded the Microsoft OLE DB Provider for DB2 but I did not have
> success configuring the connection.
> When I try to add a new Connection Manager I got the message:
>
> Test connection failed because of an error in initializing the provider. -
> The parameter is incorrect.
>
> Is there any different way to connect to DB2 using a SSIS Package?
> Could someone help me on this issue ?
>
> Thank you,
> Guber
|
|
|
|
|