DTS 'Execute SQL task' with parameters

[b00gieman]

Hi,

Is it possible to have a 'Execute SQL task' with parameters like:

if 'input_parameter'='value'
'sql_query'
else
'sql query'

?

Thanks in advance!

 

[RiverGuy]

If you're going to be changing the entire query as opposed to just a WHERE clause parameter, then a Dynamic Properties Task will work.

See here:

http://msdn.microsoft.com/en-us/library/aa933528(SQL.80).aspx