Jul 7, 2008 #1 b00gieman Programmer Joined Jul 9, 2007 Messages 60 Location DE 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!
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!
Jul 7, 2008 #2 RiverGuy Programmer Joined Jul 18, 2002 Messages 5,011 Location US 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 Upvote 0 Downvote
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