- SQL Server 2017 Integration Services Cookbook
- Christian Cote Matija Lah Dejan Sarka
- 241字
- 2021-07-02 20:41:33
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.

推薦閱讀
- Instant Testing with CasperJS
- Mastering OpenCV Android Application Programming
- Reactive Programming with Swift
- ASP.NET Core 2 and Vue.js
- Python程序設計
- Visual C++開發入行真功夫
- Building Machine Learning Systems with Python(Second Edition)
- Python機器學習算法與應用
- Python預測之美:數據分析與算法實戰(雙色)
- 現代CPU性能分析與優化
- React and React Native
- Microsoft Windows Identity Foundation Cookbook
- The Applied Data Science Workshop
- 算法訓練營:海量圖解+競賽刷題(入門篇)
- 流程讓管理更高效:流程管理全套方案制作、設計與優化