I am importing data from flat files to database. For avoiding inconsistency; if error occurs during execution of package then whole package should be rollback.
So, what I did that I marked TransactionOption = "Required". But when I tried to this then it says MSDTC service should run. Okay, I ran that service as well.
As destination server is on remote, then it does say Allow Inbound/Outbound setting needs to be done. But still, it is giving an error DTC error.
My question is that
1. Can anyone give step wise screen shots for setting MSDTC?