I am just wondering if ssis in sql 2008 r2 has a built-in scheduler which will let me run my package in off peak hour. In the development stage, I don't want to add jobs into sql server for ease of management reason if I don't have to.
I know the options of build/deploy to sql server and use the agent, or use other scheduler to run the package from cmd line/power script etc.
Nope..The built in scheduler for sql server is SQL Server Agent which is what is used for running SSIS packages as well.
If you want to schedule packages you need sql server job but that doesnt mean you need to deploy packages to server. You can put packages in a shared folder itself as .dtsx file and configure jobs to pick them and execute from file system rather than from sql server Integration services
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
does SSIS has a built-in scheduler?
Posted - 12/03/2012 : 11:17:27
