Hi,
In SSIS when you create a variable for a package, I know how to create a SQL statement in the variables expression, but is it possible to assign the result of the SQL statement in the expression to a variable and then used as a parameter in an Execute SQL Task?
I know this can be done using two Execute SQL task where first Execute SQL task runs the SQL query that I am looking to use in an expression, then second Execute SQL task uses value found in first Execute SQL task as a parameter, but I am trying to process both in one Execute SQL task. Can this be done please?
Thanks
What I have tried:
Viewed numerous youTube tutorials, attempted several various methods but Expression built SQL just shows SQL text in variable assigned to it