On the Select Destination screen, specify the server name on which the integration service has been installed. We are running this package on SQL Server, deploying the SSIS project on the SSISDB hosted on SQL Server. On the Welcome screen, you can see the details of the wizard and the tasks that are going to be performed by it. The Integration Service Project Deployment Wizard starts. To do that, open solution explorer, right-click on Integration Service Project, and select Deploy. Now, let us understand the process of deploying the package. Once the package completes successfully, it looks like the following: To execute the SSIS package, click on the Start option located in the Menu bar. The control flow window looks like the following image: We want to keep the free space in database files, so I have chosen the “ Retain freed space in database files” option. You can set an option to keep the free space in database files or return the free space to the operating system. Once the task reaches the specified values, it will stop the execution. Specify the amount of free space that you want to keep after the shrink operation completes. Specify the size of the database that will trigger the execution of the Shrink Database Task. We want to shrink the AdventureWorks2017 database, so select it.īack to the Shrink Database Task dialog box, specify the following parameters. Now, select the desired database from the Databases drop-down box. Screenshot of connection properties dialog box: We can use SQL Server authentication as well as Windows authentication.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |