In this demo, the package must rebuild the index of all databases. Once the connection is established, the databases’ list fills in the Database(s) drop-down box. Specify the connection name, the server name, and the authentication method to logon to the server.Ĭlick OK to save the settings, and close the window. It will open the Connection Properties Dialogue window. Double-click it, and the Rebuild Index Task dialogue window will open.įirst, click on New to create a new connection to the server. Here we need to configure the rebuild index task. On the New Project dialog box, select Integration Services Project ,and name the Project:ĭrag the Rebuild index task from the SSIS toolbox and drop it on Control Flow designer. Open SQL Server Data Tools > File > New > Project: Once it is downloaded and installed, create a New SSIS Project. We can create the integration services package using SSDT for Visual Studio 2017. Create an SQL Server Agent job to automate the execution of the SSIS package.Deploy the SSIS package in the Integration Services catalog.Create an SSIS package that rebuilds all the user database tables indexes.To demonstrate the process, we will perform all following jobs in practice: Practical creation, deployment, and execution of SSIS package 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.

How to view ssis package