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.



Conclusion
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.

Pages: 1 2 3 4




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |