Hello ramkumar,

Thanks a lot for your response...

It would be great if you can let me knwo what has to be changed in the DB2 Client Driver.

By the second statement ,do you mean to use OLEDB data provider for db2 in SSIS data flow task rather than using the ADo.Net Data source Task ??

Am using Ado.net source task..but Am not sure regarding the setting of DB2 Properties in the SSIS

I face this Issue only when I try to pull information from the DB2 Database source,by running jobs in two different servers at the same time.

I also tried tos et the command timeout property of Ado.net source to 0 .But still I get this error

kindly please elaborate regarding the fix..

I would be highly obliged.

Thanks in advance!!