上QQ阅读APP看书，第一时间看更新
How to do it...
- With the CustomLogging project opened, right-click on the CustomLogging.dtsx package and select Copy as shown in the following screenshot:
- Now, right-click on the SSIS Packages folder and select Paste as shown in the following screenshot:
- A copy of the package is created and named CustomLogging 1.dtsx as shown in the following screenshot:
- Right-click on the newly created package, CustomLogging 1.dtsx, and select Deploy Package from the menu as shown in the following screenshot:
- As shown in the following screenshot, the Server name is already selected since we've deployed the project there before. It can be changed if necessary. The Path is where the deployed package will be located; the SSISDB/CustomLogging/CustomLogging folder in the SSIS Catalog. Click Next to advance to the next step.
- Now we are at the Review screen as shown in the following screenshot.
Notice that the package to be deployed is CustomLogging 1.dtsx . It is tagged as Package#1 since we might have selected multiple packages to deploy. Click Deploy to proceed to the deployment.
- If everything goes well, you should get a screen like the following screenshot meaning that the package has been successfully deployed. Click on Close to get rid of it.
- Now, go to SSMS and open the SSIS Catalog as shown in the following screenshot. You will see that the package has been deployed. We won't execute it for now as we only wanted to demonstrate how single package deployment works.
