Scheduling a SSIS Package with SQL Server Agent
Executing Newly Created SSIS Package Job Manually
You can manually execute the newly created “Execute SalesCustomer SSIS Package” job by right clicking “Execute SalesCustomer SSIS Package” Job under SQL Server Agent | Jobs node as shown in the snippet below.
Once the “Execute SalesCustomer SSIS Package” SQL Server Agent Job has executed successfully it will generate the SalesCustomer.txt file as shown in the snippet below.
In this article you have seen the steps which you need to follow in order to create a new SQL Server Agent Job using SQL Server Management Studio (SSMS) to schedule the SSIS package which was stored as file system. You can follow the same steps to schedule an SSIS package which needs to run in SQL Server 2005.