Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 13th, 2015, 03:52 PM
Authorized User
Points: 157, Level: 3
Points: 157, Level: 3 Points: 157, Level: 3 Points: 157, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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?
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 04:36 PM
XML native databases codesamurai XML 2 January 28th, 2006 12:13 PM
Native PDF Classes? Aaron Edwards ASP.NET 2.0 Basics 1 September 17th, 2005 06:02 AM



All times are GMT -4. The time now is 01:56 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.