Hi

I've got an SSIS package that I want to run on demand and pass in some parameters which can be used by SQL in the package.

I tried saving the parameters in a temporary table so they could be picked up in my SQL but this fails with a permission error.

Anyone got advice on the best way to pass a parameter into an ssis package,.

Thanks





.