This article explains how to create an SSIS package using SQL Server Data Tools, deploy it with the Integration Service deployment wizard, and automate its execution through the SQL Server Agent job.

Practical creation, deployment, and execution of SSIS package

To demonstrate the process, we will perform all following jobs in practice:

1. Create an SSIS package that rebuilds all the user database tables indexes.
2. Deploy the SSIS package in the Integration Services catalog.
3. Create an SQL Server Agent job to automate the execution of the SSIS package.

We can create the integration services package using SSDT for Visual Studio 2017. You can download it here.

#sql server #sql server agent #ssis #sql