March 7, 2016 at 10:00 am
I am new to creating SSIS 2008 packages. What I want to do is to create a simple SSIS package and have the users 'run' the package when the needs arise. This cannot be a scheduled job since a user needs to determine when there is enough data to process.
Is there some tool SSIS tool? Is there some kind on excutable, dll, and/or app the user can click on to run the package?
Thus can you tell me and/or point me to ways that I can setup a process for a user to execute the ssis package?
March 7, 2016 at 10:14 am
One way is to create a SQL Agent job which runs the package.
Then allow the user to run a proc (possibly using EXECUTE AS to escalate the rights of the process) which runs sp_start_job to execute the job.
This will run the job asynchronously, so if you need to provide feedback, you'll have to think about ways of doing that (notification e-mail, flag in DB etc).
March 9, 2016 at 8:35 am
What other options do I have?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply