Platform: Windows Vista, MSDTC enabled, sql 2005 Dev edition installed.
I was using SSIS to import an MS Access database into a
sql table. The process ran fine so I decided to encapsualte the
process in an SSIS transaction (by setting TransactionOption to Required).
The BIDS designer didn't complain but the runtime sure did. Here's the error:
>>>>>>>>>>>>>>>
Connection manager "My Access File": The connection does not support enlisting in distributed transaction.
An OLE DB error has occurred. Error code: 0x8000FFFF.
>>>>>>>>>>>>>>
Does the OLE DB provider, as stated, simply not support MSDTC? If so, is there
a "transactional" way to do what I was trying?
TIA,
Barkingdog