locked
How to use parameters in Execute T-SQL Task query RRS feed

  • 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

    Friday, July 15, 2011 11:34 AM

All replies

  • 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
    Jamie Thomson
    Friday, July 15, 2011 1:54 PM
  • Parameter menu is for package parameters while calling child packages using execute package task.
    Thanks Ayyappan Thangaraj, http://SQLServerRider.wordpress.com
    Thursday, July 21, 2011 7:27 AM
  • 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

    Friday, March 23, 2012 12:15 AM
  • 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.

    Friday, March 23, 2012 7:14 AM