We are going with the stored proc solution. click button , runs procs, returns #.

I really wanted the ssis to work and the concept worked in VS just not the execution from remote Excel. I made other packages for the same project and hoped to keep them together. Alas back to straight SQL. 🙂

thanks

S