Deploying and Configuring SQL Server Integration Services Packages Without the Wizard
Job Creation & Execution
Scheduling a package requires that a SQL Server job be created for the package. Load the Database Engine server type and connect using the LocalHost server name with Windows Authentication. After connection, navigate to the bottom of the LocalHost directory and expand the SQL Server Agent folder. Right-click on the Jobs folder and choose New Job... to display the New Job window. as seen in Figure 7.
Give the job a name and navigate to the Steps tab on the left side to create a step process. Click on New... and a New Job Step window will appear, as seen in Figure 8.
Figure 8: SSIS Step Creation
Give the step a name and select SQL Server Integration Services Package as the type. Ensure that the value of Run as is SQL Agent Service Account. Now, navigate to the General tab located below the drop downs and select SSIS Package Store as the package source. Input LocalHost as the server and browse for the package in the file system. Select a package and the window should now resemble Figure 8. Click OK to close the window.
Now that the step is created, the package needs to be scheduled. Navigate to the Schedules tab on the left side of the New Job window and click on the New... button to display the New Job Schedule window. As seen in Figure 9, the New Job Schedule window is pretty self explanatory. Set the desired schedule and click OK to exit the scheduler.
Figure 9: SSIS Job Scheduler
Page 3 of 6