using xp_cmdshell to execute an SSIS package

Hello experts.

I have an SSIS package developed on my local machine that I need to put into production. It will run when a user presses a button on a website and it will run nightly as a scheduled job. My first attempt was to create a stored procedure that calls xp_cmdshell to run the .dtsx file but it looks like there could be some security holes with this approach. Are there any recommended alternatives?

Thank you.
Who is Participating?
brad2575Connect With a Mentor Commented:
You can just use use the website to execute the job that you have scheduled to run nightly.  That way it would still run nightly and whenever the user presses the button (assuming you would restrict the website to whoever should have access to it only).
Chris MConsulting - Technology ServicesCommented:
I guess you want to give control to the user to choose when to run the job from the website.
You optionally can create an underprivileged user on the OS and database who can run this SSIS package. Then optionally may use some database trigger to handle the event where you can stop any other user from invoking the job from a different location.

I think the options are still available.
Reza RadConsultant, TrainerCommented:
if you want to run your ssis package, so use DTEXEC , you don't need xp_cmdshell then.

Reza RadConsultant, TrainerCommented:
this is more about how to run package by dtexec:
dpiccoAuthor Commented:
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.