Use parameters with Execute SQL task

Question

Use parameters with Execute SQL task

Viewing 5 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Kathi Kellenberger SSChampion Points: 11811 More actions · Answer 1

Well, for the chapter example I was working on, using parameters was less messy than a dynamic statement. I also wanted to use an output parameter. Believe me, I tried a bunch of different approaches. I think it all depends on the problem you are trying to solve.

Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor

Kirk Haselden SSCommitted Points: 1683 More actions · Answer 2

Ah, output parameters...

Well, now, that's a different story altogether, isn't it. Eh hem...

K

Lori-296222 Valued Member Points: 69 More actions · Answer 3

Sorry to say but the book has a lot of bugs with regards to the output parameters. SSIS seems to be extremely difficult for setting output parameters. I'm running into issues where the data type for a variable and data types for parameter mappings are different and i receive errors about how they are not set properly. Extremely irritating when all I'm trying to do is set a variable to an integer.

select max(id) from table. I'd like to set a variable to that as an output parameter.

THoughts?

Jakub Rycombel SSChasing Mays Points: 640 More actions · Answer 4

Please try to do the following - in parameter mapping replace "?" with "0". I did it like that with OLE DB data source and worked.

Select ProductID, ProductName

from Production.Product

Where ProductID = ?

The Parameter mapping page looks like this:

User:roductID, Input, Long, 0

vidyasagar.sql SSC Enthusiast Points: 190 More actions · Answer 5

vidyasagar.sql

SSC Enthusiast

Points: 190

July 23, 2013 at 9:46 am

#1635041

Its Awesome. Working for me in SQL SERVER 2008 R2