Lesson 12 SQL Task
Lesson 12 seemed to be a pretty simple concept and perhaps it is but this being my first exposure to SSIS I am apparently missing something.
I can work the example in the book and it works flawlessly so I am thinking that I could modify the example and change result set to a string variable and amend my SQL statement so that instead of returning COUNT(*) for a ProductID it returns the "Name" value for that ProductID.
This however errors out in the SQL Task component of the package BUT when I declare the variable in SSMS and set it to 316 my SQL query performs just as you would expect and returns the "Name" value of "Blade".
What am I missing in SSIS SQL Task that would allow me to successfully execute package?