How To Execute SSIS Package Using SQL Job

In my previous article, you can learn how to deploy SSIS Package to SQL Server. Now we have deployed SSIS package in SQL Server.
 
Logged in to SQL Server, go to Integration Services Catalogs to see deployed packages.
 
How To Execute SSIS Package Using SQL Job
 
Now go to Jobs in AQT Server Agent and right click on Jobs and click New Job…
 
How To Execute SSIS Package Using SQL Job
 
In General tab, provide job name, Owner, Category and Description.
 
How To Execute SSIS Package Using SQL Job
 
In Steps tab click New button.
 
How To Execute SSIS Package Using SQL Job
 
Now select job type as SQL Server Integration Services Package and Run as SQL Server Agent Service Account.
 
In Package tab, select SSIS Catalog for Package source and Server and choose authentication type and provide user name and password and browse Package location.
 
How To Execute SSIS Package Using SQL Job
 
In Schedules tab, provide schedule name and schedule frequency and other details and hit ok button
 
How To Execute SSIS Package Using SQL Job
 
If you want to run job right away then right click on Job and hit Start Job as Step…
 
How To Execute SSIS Package Using SQL Job
 

Conclusion

 
In this article, you have learnt how to run execute SSIS package through SQL Job.