I want to know what are the requirements to execute a dts with tasks joined to transactions in it. I'm asking about requirements related to services, user privileges and so on
this info applies for a general problem that is how to execute a transactional dts, what is needed.
Anyway here's my specific problem right now. I have experienced several problems due to transacctions: first, with MSDTC service running in server machine (where SQLServer is running) I cannot execute successfully the dts unless MSDTC also running in my local machine. Also is not possible for my user to execute DTS from dts editor unless my user being sysadmin in SQLServer server machine. So i want to know what is exactly necessary to execute such kind of DTS (transactional DTS) in terms of services, security, user profiles and roles, etc