FYI

I was able to resolve this problem by adding backup servers to permissions on the filer and also giving access to the filer root just for "trouble" servers.

It is all...

It looks like your issues\causes are different from mine.

I do not have any sorts\merges. It is a straight SELECT from DB2 table (only one of them) and load into SQL...

If you use the same software\version it should be there.

You can try "db2cmd" command and issue

> db2 update cli cfg for section common using CursorTypes 6

This is the info

I found one pattern:

There are two ways to specify source (DB2)

Specify table or view and just select it from the list. In this case access mode is OpenRowSet

Specify...

I had to completely rewrite them because most of the "stuff" was not supported by SSIS and they were working fine until DB2 side changed to run under Linux.

Normally this provider is not supplied on its own (I could be wrong about that), but comes with the product, in most cases DB2 Connect.

As a sql server person you...

Data Pump = Transform Data Task.

That is exactly what I am talking about: Data Pump task of DTS SQL server 2000.

It is used to load data between different sources\destination and it is the one...

If you are using DB2 Connect to connect to Linux DB2 from DTS package running DTS Data pump it happens because by default StaticCursor is selected and DB2 does not...

Actually Microsoft OLEDB Provider worked because it was setup as "InProcess" by default. As soon as I setup IBM DB2 Provider as "InProcess" it started to work too.

This is how...

I encountered exactly the same problem and can add that if you switch from IBM OLEDB provider for DB2 to Microsoft OLEDB Provider for ODBC on on Linked Server configuration...

Hello, our DB2 was converted to Linux and I am facing exactly the same problem. I replaced Data Pump with ActiveX for now. Did you figure it out? Thanks.