{[['
']]}
![](http://static.graddit.com/img/star.png)
Schedule SSIS Package
First SSIS package that needs to be scheduled
Create new job from SQL Server Agent Menu.![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitRLvv6rDw4KguCLhqDaUBnc42DFultniWkYejnHAI1L2SmQVlJtlXt6Mmo3ICd1rQYgdrd25bBslaeS_2c4p4O6Zjt82vHs8ZO9ezchUNS-VUC5S8QfBboyc9268QCwabTVT66v9YniU/s320/01.png)
Create New Step.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXh6ttkGPqxLLRZYEOV7kFrEk9hibtDAIm97-J2LaAoSpcwjlmWb8sT6Wfx9nDGD-X1Hz2aWpsGiqWe5tW6lq6k8TBTmk9lHo3yWw7rh4RgFwf5AashGrHJfVQCCp16DLA5z8scC4sYWk/s320/02.png)
Select Steps then Select New.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLdcq1KcK-GZX5jQwtACugR4qEmq49BdGvAzyYZQzPG6dTZtzLXaxGy4DJeyY7joFByQJqD-9JwfDERkfIgF3vOyGYOSCr8S8WVAbF8S7VtFwCXJtNI0cVD0fbKtZgUF1-fZQ4olto660/s320/03.png)
Select Type as SQL Server Integration Services Packages. Select Package Source as file system and give package path.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7flSgvChmeLE3tatQWaMYquXJRzWacwP2mllBonnMVKMjnEq543dgOyAGhr6ePFKDgLwa0FCv4oQmganWhTzyd4qR00IPLub9xmRoeFcpnRWlK5IsqDI01SJBO2wtqsScxGPhd-FFOdQ/s320/04.png)
Press OK.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjoTnAwNhdgubZcvj58PQWSYMHxA8Dh8cQFtTC0mgmb1MNYYGfdkze8FVjE_xG27ESFTIhLUk6fN7fZANoLkhzN-IKYUlZKBMBoQlldyiO34MOLSUwrrtIddAWnN40vz_whd3MOOG2Ijw/s320/05.png)
Select schedule.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilz8c4kL2M-99McgaN63Rw_ElRKO_vzpcxcdp9njPdLFfabo0hF6EDOy41iTVLqjFg3el7kf06oddxM_OiwWPXf0VTtJ3RaB-RFDxbnLYuVZ5KmJUWufmib-klvhna4XkcwiokH9Jcbvo/s320/06.png)
Configure the desired schedule.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQnZLe-CfzkjmK_ti377AWtn_AyrmCR0ugpAROAYokOQXmxLBLjrcWEL8-KrWYHzrg8XCy8LCAxcz7pXW5lIWa7byHt-6nxnavCN4br-3elNZKzKMIa0L0n0cj2AvP7afINXOqSr3am6M/s320/07.png)
Post a Comment