Im confused. Surely it would be easier to write the results of your SP (Stored Procedure) into a table, thats overwritten each time the DTS is run. Once its in...

what do you mean by assign appropriate global parameters collection?

I dont care where the SP is run, the SP inserts data into an existing table.

Thanks for your reply.!