I am facing a specific issue due to the Transaction Coordinator. Currently 2 of my SSIS packages run in parallel, the first one to start is able to process and insert the data into Target database. The second packages run successfully but actually doesn’t insert any records(surprising?). So the 2nd packages doesn't give any errors but just executes silently and finishs without creating any records.
Considering that I have changed system to run only one packages at a time.
Now my question is: in case multiples packages are running on DTC, is it possible to somehow fail one of them and return error to the SSIS so that the package can be run again.
Also can we run packages in parallel in DTC with any specific setting and something I can do so that the packages runs parallel?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.