tag:blogger.com,1999:blog-7468857462999845094.post8541237225966088301..comments2024-03-28T12:49:31.068+05:30Comments on Microsoft SQL Server Knowledge Bank: SSIS – Related to Transaction in Case of Parallel ProcessingMR. JOYDEEP DAS (MVP-SQL Server Year 2012, MVB - D-Zone, MCDBA, MCSE, ADSE, CSI)http://www.blogger.com/profile/15813518881162145877noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7468857462999845094.post-43948047272059427652015-12-11T16:53:10.135+05:302015-12-11T16:53:10.135+05:30Another Good Article related to DTC Enabled in Clu...Another Good Article related to DTC Enabled in Clustered Server<br />http://sqlha.com/2013/03/12/how-to-properly-configure-dtc-for-clustered-instances-of-sql-server-with-windows-server-2008-r2/<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-37374019668513613432015-12-11T16:26:05.834+05:302015-12-11T16:26:05.834+05:30MSDN Reference to Enable DTC
https://msdn.microsof...MSDN Reference to Enable DTC<br />https://msdn.microsoft.com/en-us/library/ms936442(v=cs.70).aspx<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-9973291285938891402015-12-11T14:11:33.532+05:302015-12-11T14:11:33.532+05:30Please Note that if we Do not want to use the DTC ...Please Note that if we Do not want to use the DTC in transaction, in this scenario we have a single connection against for all the Task and the Retain same connection property must be set TRUE.<br />Now we can use BEGIN TRANSACTION, COMMIT TRANSACTION and ROLLBACK TRANSACTION within different task in SSIS.Anonymousnoreply@blogger.com