Need help w/ simple SSIS task

[katbear]

Hello,

Basically, all I am trying to do is create an SSIS pkg that will read a list of stored procedures from a table (and then execute them and output to a file).

I set up an EXECUTE SQL TASK to do the first part, that is select the sp name from the table. I am saving the result set to a variable (type object).

Next, I call a FOREACHLOOP container, which references the variable from the EXECUTE SQL TASK.

But I'm not sure what to do next?? I just want the FOR EACH LOOP to simply execute the stored procedure name as given by the first EXECUTE SQL TASK.

I was thinking to put another EXECUTE SQL TASK inside the FOR EACH LOOP, but I don't know how to reference the stored procedure name correctly, or if this is even allowable.

I am not a scripter - will this require scripting? Or is there a clever way to run another EXEC SQL TASK that can simply reference the stored procedure name, ie) the variable, and execute the stored procedure??

Thank you!!!

 

[ptheriault]

Kat,
You may have more luck with this question if you post it in the SSIS forum.

- Paul
- If at first you don't succeed, find out if the loser gets anything.