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