How To Execute SSIS Package Using SQL Job

In my previous article, you can learn how to deploy the SSIS Package to an SQL Server. Now we have deployed the SSIS package in SQL Server.

Logged in to SQL Server, go to Integration Services Catalogs to see deployed packages.

Now go to Jobs in AQT Server Agent and right click on Jobs and click New Job.

In the General tab, provide the job name, Owner, Category, and Description.

In the Steps tab click the New button.

Now select the job type as SQL Server Integration Services Package and Run as SQL Server Agent Service Account.

In the Package tab, select SSIS Catalog for Package source and Server choose authentication type provide user name and password, and browse Package location.

In the Schedules tab, provide the schedule name schedule frequency, and other details and hit the ok button.

If you want to run a job right away then right-click on Job and hit Start Job as Step.

Conclusion

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