Database Administrators often get requests from development teams to deploy and schedule newly created SQL Server Integration Services (SSIS) packages across different environments. In this article you will see the steps that you need to follow in order to schedule an SSIS package as a SQL Server Agent Job using SQL Server Management Studio (SSMS). SQL Server Agent Jobs can be used to schedule and execute SSIS Packages which are stored in SQL Server, or in File System, or in the SSIS Package store. When we say a SSIS Package is stored in the SSIS Package store, it is basically stored as a file within SQL Server’s “C:\Program Files\Microsoft ..
|
