ExecuteSQLTask

Hey everybody,

Is there any ways that I could execute a "ExecuteSQLTask" from a script task inside the package. I mean both "ExecuteSQLTask" and "ScriptTask" are in the same package.

Any tips?

Thanks

Ryan

Just curious. Why do you want to execute "Execute SQL Task" from a script task?|||I have a set of rules in a table and depending on each rule type I have to execute a different step.|||

Why do you think that being able to fire an Execute SQL Task from within a Script task will help you with this?

Your best bet would be to loop over the rules using a ForEach loop and then use conditional precedence constraints within the ForEach loop to decide which Execute SQL Task to execute.

-Jamie

sql