September 19, 2018 at 2:36 pm
Is there any way to schedule SSIS Packages to run without deploying them to the SQL Server?
September 19, 2018 at 3:39 pm
Yes.
Just copy the packages or the ispac file to a location that your scheduler software (or SQL Server Agent user) has access to and then use the command line dtexec with the required/desired parameters to execute the package.
If on SQL Server job you would do this through a command line exec step.
see https://docs.microsoft.com/en-us/sql/integration-services/ssis-quickstart-run-cmdline?view=sql-server-2017 for possible ways to do it
and https://docs.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility?view=sql-server-2017 for the documentation on dtexec itself
Note that the packages can be either in package or project deployment mode and each mode will have its unique quirks
Only requirement is that the server where you execute the package needs to have a fully licensed installation of SQL Server (Enterprise or Standard)
September 19, 2018 at 6:31 pm
You could write a .bat or PS script and execute on a schedule using Window Task Scheduler.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply