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

推薦閱讀
- C++面向?qū)ο蟪绦蛟O(shè)計(jì)(第三版)
- 計(jì)算思維與算法入門
- Mastering ServiceStack
- Visual FoxPro程序設(shè)計(jì)教程
- Raspberry Pi Networking Cookbook(Second Edition)
- ASP.NET Core Essentials
- Java程序設(shè)計(jì)與實(shí)踐教程(第2版)
- Kinect for Windows SDK Programming Guide
- 零基礎(chǔ)學(xué)Python網(wǎng)絡(luò)爬蟲案例實(shí)戰(zhàn)全流程詳解(高級進(jìn)階篇)
- Learning Zurb Foundation
- Salesforce Reporting and Dashboards
- Django 3.0入門與實(shí)踐
- C++編程兵書
- 零基礎(chǔ)學(xué)C語言程序設(shè)計(jì)
- Visual Basic程序設(shè)計(jì)全程指南