April 13, 2019 at 10:23 pm
Hi i am doing tutorials from the book "Microsoft SQL Server 2012 Integration Services: An Expert Cookbook".
I am getting error when i execute this task(Chp.1, task 1) as stated in the book, WHY? It runs when i don't select "single row"
Please also explain step 9. The author does not elaborate on how to create this package with all it requires?
April 16, 2019 at 2:08 am
Yup, it looks like they missed a step. I thought there was an errata at one point for that book but it's not on the main apress site that I can see https://www.apress.com/us/book/9781484200834
The error this generates, "Execute SQL Task: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_SingleRow"." can be resolved by clicking on the Result Set tab.
Click on the Add button
Click Ok, Ok and then run. It should go green
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply