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:40 PM
Authorized User
 
Join Date: Apr 2015
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default Checkpoint file contents are uninformative

In Ch 14, 'Inside the Check point file' I set up the 3 scripts tasks, and task 3 failed as designed, but a check point file without an error is not very informative. So in task 3 I put in a try-catch block so that upon the failure another user variable (string) would be set with the error message. The catch did execute and the error variable was assigned a meaningful value and this error variable was presented in the check point file but it had no value in the file. Is there a way to get the error message?

Last edited by get inc; August 12th, 2015 at 03:03 PM.. Reason: additional information





Similar Threads
Thread Thread Starter Forum Replies Last Post
Ch 8 Ex-Dimesion_Key_Fuzzy... has a checkpoint DrewMorris BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution 1 October 22nd, 2013 01:17 PM
how to sorti file contents lakshmi_annayappa Java Basics 4 March 20th, 2008 05:26 AM
Extracting contents of a war file.. Pallav J2EE 1 September 24th, 2004 12:02 PM
Dividing contents of 1 excel file into many Wire Excel VBA 1 April 12th, 2004 05:44 AM
How do I Save a form's contents into a .txt file flyingfox Pro VB.NET 2002/2003 2 March 28th, 2004 01:03 PM





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