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 02:02 PM.