sql server dts: I am using the IBM OLE DB Provider for DB2 from SQL Server Integration
Services. I can connect and read the DB2 tables with no problem.

My issue is that I can not get it to work as part of a transaction.
Has anyone done this? is it even possible?

Thanks
Borf

Hello Borf:

I also use the DB2 connector, but ONLY as a Source adapter. I use
Transactions in my SSIS Packages by creating two Execute SQL Tasks in the
Control Flow and set them to BEGIN TRAN and COMMIT TRAN. These are connected
to a SQL connection, not DB2.

Since DB2 is read only, it doesn't really matter.

Not sure I helped you out here.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


[quoted text, click to view]