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 13th, 2015, 03:52 PM
Authorized User
 
Join Date: Apr 2015
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default C4 14 Native Transaction ... failure path

For Ch 14 example Single Package Using a Native Transaction in SQL Server, I created this example and executed it to create the table. Thinking that I'd like to see the failure path followed, I executed it again. The Create Table task failed, of course, but so too did the Rollback. In the Execution results I see the 'table already exists' error message, as expected, but also the error message that the ROLLBACK has no corresponding BEGIN TRANSACTION. I do have a BEGIN TRANSACTION. Did anyone else get this error?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to execute the c4 Merging files package...throws me errors. RogerZebra BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution 1 August 27th, 2011 06:31 PM
absolute path vs relative path for substitution group elements ptn77 XSLT 3 June 16th, 2011 10:04 AM
Managed C# and Native C++ han_nomad C# 1 February 22nd, 2007 05:36 PM
XML native databases codesamurai XML 2 January 28th, 2006 01:13 PM
Native PDF Classes? Aaron Edwards ASP.NET 2.0 Basics 1 September 17th, 2005 06:02 AM





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