rwheeler23
asked on
SSIS 2012 package to run on demand
I have an SSIS package that is scheduled to run each night. Now there will be times when the users need to run the package whenever necessary. What are my options to allow them to do this without having them going into SSMS? Can this be done from the command line? Can this be done using a stored procedure? I could create a VS program that allows them to run a stored procedure so this may be an option.
You can use dtexec utility.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good idea. Thanks.