I hope this is the right forum to post, else please let me know.
I'm not an expert with SSIS but I have to maintain and extend some packages and am stuck with following problem: I need to run a stored procedure on a table, created earlier in the package, for each "client" in that table.
What the stored procedure does, is select informations according to the client number and output it in a text file. The stored procedure call is EXEC SP101 'LIVE','Client1' then 'Client2', ...
The part of the SSIS package that does this is
1. <<Execute SQL task >> that selects all the distinct clients and puts the result in a system.object
2. <<For each container>> with link to the collection retrieved above
1. <<Execute SQL task >> that executes the SP EXEC SP101 'LIVE',? with parameter mapping to the client id, but not sure I did it the right way.
My problem is that, although the SP is run a correct number of times, no data are generated. It seems the clientID is never passed to the SP.
If you need any further information, please let me know.
Any help will be much appreciated.
Thanks a lot