How to use parameters in Execute T-SQL Task query

Question

I do not find the dialog for mapping package variables to sql parameters in the query. Is this missing from CTP3? Do any know how to do this?

There is a Parameterize menu item when right-clicking the task, but I don't see how to translate this into the query.

\\Vemund

Answer 1

Are you inside the Execute SQL task or the OLE DB Source?

I was using both (on CTP3) just yesterday and was able to map parameters successfully in each of them.

 

The parameterize menu item is there for another reason - its not relevant to mapping parameters to a query.

---

http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Answer 2

Parameter menu is for package parameters while calling child packages using execute package task.

---

Thanks Ayyappan Thangaraj, http://SQLServerRider.wordpress.com

Answer 3

As in 2008/2008 R2, if you need to run parameterized queries ... you should use the Execute SQL task instead of the
Execute T-SQL Statement task (http://msdn.microsoft.com/en-us/library/ms139753(SQL.110).aspx)

---

Carla Sabotta

Answer 4

As in 2008/2008 R2, if you need to run parameterized queries ... you should use the Execute SQL task instead of the
Execute T-SQL Statement task (http://msdn.microsoft.com/en-us/library/ms139753(SQL.110).aspx)

---

Carla Sabotta

I didn't even realize there was a TSQL task. Not sure it really has any use...

---

MCTS, MCITP - Please mark posts as answered where appropriate.