- 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.

推薦閱讀
- Web前端開發技術:HTML、CSS、JavaScript(第3版)
- 算法基礎:打開程序設計之門
- 深度學習:算法入門與Keras編程實踐
- Interactive Applications Using Matplotlib
- Apex Design Patterns
- 小程序開發原理與實戰
- iOS編程基礎:Swift、Xcode和Cocoa入門指南
- 微信小程序項目開發實戰
- Getting Started with LLVM Core Libraries
- OpenResty完全開發指南:構建百萬級別并發的Web應用
- Java SE實踐教程
- 網絡數據采集技術:Java網絡爬蟲實戰
- 計算機應用基礎(Windows 7+Office 2010)
- 透視C#核心技術:系統架構及移動端開發
- Python人工智能項目實戰