SQLTeam.com | Weblogs | Forums

Begin Transaction and commit causing issue in SP calling package - 2012


#1

Hi Experts,

Need Help

I am working with SSIS 2012. Created parent package and 4 child packages. Deployed the package (Project deployment Model) on server. Project parameters are created in Visual Studio only. Basically I have input dates parameters and connection strings. This master package is being called by store procedure. And I am using Begin Transaction and Commit in store procedure. But when I started executing procedure but nothing is happening. My package is not executing. I have checked the MSDTC and it is checked in both the servers (Source and Destination).

Pleaase let me know if I am missing anything here

T.I.A