Hi,
I have problems with SSIS transactions with X64 sever. My package is simple:
1'st step "truncate table A", 2'nd - copy data from oracle table into sql
table A. I set TransactionOption = Required in package options and
TransactionOption = Supported in both steps. I get error "Unable to enlist
in the transaction". This error I got in 2'nd step in "OLE DB source" item.
I did all steps described in http://support.microsoft.com/kb/839279 , but
problem persists.
Does anyone slved this problem?

Thanks.

Ramunas