Wrox Programmer Forums
|
BOOK: Professional Microsoft SQL Server 2012 Integration Services
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2012 Integration Services by Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock; ISBN: 978-1-1181-0112-4
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2012 Integration Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 12th, 2015, 01:12 PM
Authorized User
 
Join Date: Apr 2015
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ch 14 Containers within Containers ... distributed services

In the Chapter 14 example 'Containers within containers and Checkpoints' I changed the TransactionOption property to Required and upon executing the package I got the error message:
Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running.
I navigated to and executed:

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Administrative Tools\Component Services (Shortcut)

and expanded Services (Local). The Distributed Transaction Services was reportedly 'Running'. I double-clicked this row, and a Window popped up. I stopped the service, then then Started it. I re-executed the package and it succeeded.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Get Containers in Chp 4 to work smitman34 BOOK: Beginning ASP.NET 4 : in C# and VB 5 February 11th, 2012 05:00 AM
CH.14 - Web Services Example Site Down Dexor BOOK: Beginning iPad Application Development 1 July 5th, 2010 10:11 PM
Values in Containers DoubleDiamond007 C# 2005 1 March 25th, 2008 04:44 PM
Placing controls in containers at run time. HotBlue VB How-To 2 October 13th, 2006 05:58 PM
Distributed Transaction in different web services avanishp .NET Web Services 1 December 16th, 2004 12:39 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.