>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
>
>
>
>
>
>.did you check the permissions on sql server database?
nick