>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
>
>

Hi, Nick, the best way is to create configuration variables.

How are you executing this package - as an Agent job, from a stored proc, from a .NET app, etc?

I see you posted this about two weeks ago. If you're still looking for an answer, I can give you some samples.