SSIS Package deployment details

Step 1: In Visual Studio, Select Project à Properties as shown below.

 

D1.png

 

Step 2: Click Deployment Utility (from Left side) and change Create Deployment Utility value to True.

 

D2.png 

 

 

Step 3: Build the project.

 

 

 

Step 4: Open the <Project>\bin\Deployment folder and double click the ProjectName.SSISDeploymentManifest file.

 

D3.png 

 

 

 

 

 

Step 5: Click next in the Welcome wizard page.

 D4.png

 

Step 6: Select SQL Server deployment option.

 

 D5.png

 

 

Step 7 : In the server name textbox, specify the SQL Server name and use SQL Server authentication. Use sa username(User having deployment permissions) and related password.

 

 

 

 D6.png

 

 

Step 8: Click the Package path option and select “Maintenance Plans” folder.

 

 

 

 

 D7.png

 

 

Step 9: Click Next.

 

 

D8.png 

Step 10: Click next.

 

 

D9.png 

 

 

Step 11: In the confirmation installation window, click Next.

 

 

D10.png 

 

Step 12: From this window shoes the list of deployed packages. The Deployment is successful and the packages are ready for execution. The packages can be scheduled as per the requirement but the execution sequence should be in the specified order as per Package Execution Sequence to avoid dependency issues.

 

 

 

D11.png


Hope this helps.

Ebook Download
View all
Learn
View all