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 17th, 2015, 07:26 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 Ch 14 ParallelDemo.dtsx ... parallelism

Regarding Ch 14 ParallelDemo.dtsx, I will add the errata that Figure 14-45 is wrong in indicating that User::strSQLStatement is the 2nd parameter variable; User::strWherePartition is the correct variable.

The batch file, p. 484, references the wrong DTSX package, Worker.dtsx, when it should be referencing ParallelDemo.dtsx. You will see this correction in the downloadable code.

The ParallelDemo package has a loop, and I guess that what we want is for each iteration of the loop, i.e., each SELECT of Sales for a specific year and whatever other tasks are added to a loop, to occur in a separate thread. The batch file seems to have another loop that executes ParallelDemo.dtsx multiple times (5?) When we seem to have a loop within a loop, it is unclear how we get to each iteration of the Loop task to be in different thread. This is very poorly explained.

I tried running the package within VSDT, that is, not from the batch file, and received the error message: [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_SingleRow".
In the 'SQL Checkout Work' task I changed the ResultSet property value from single row to none, and the error went away. The stored procedure ctl_UseTask does not, afterall, return any records; it outputs parameter values.

Last edited by get inc; August 18th, 2015 at 01:02 PM. Reason: typos
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
Error in Ch. 14 Try It Out FrugalRacer BOOK: Beginning ASP.NET 4 : in C# and VB 5 September 29th, 2014 06:38 AM
ch 12-14 Databases AlanWheeler BOOK: Beginning ASP.NET 4.5 : in C# and VB 2 February 21st, 2014 01:30 PM
Ch.14 first try it out lrk89 BOOK: Beginning ASP.NET 4 : in C# and VB 7 February 10th, 2014 04:12 PM
Ch.14 - First try it out jxFive BOOK: Beginning ASP.NET 4 : in C# and VB 3 November 3rd, 2011 03:55 PM
Ch 14 Help digink BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 November 3rd, 2009 02:35 PM



All times are GMT -4. The time now is 10:15 PM.


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