如何部署你的SSIS封裝:
1. 選擇專案 > [Package Name]屬性
2. 選擇部署公用程式, 右側的 CreateDeploymentUtility 從 False 改為 True (注意: DeploymentOutputPath 在 bin\Deployment), 按確認
3. 在剛剛 DeploymentOutputPath 路徑中找到 [Package Name].SSISDeploymentManifest 檔案, double click 後 follow 封裝安裝精靈的步驟
測試已部署的封裝
1. 開啟 SQL Server Management Studio, 連接 Integration Services
2. 剛剛部署的封裝會在 File System 或是 MSDB folder 底下仰賴剛剛所部署的方式, 找到你要測試的dtsx檔之後, 按右鍵去"執行封裝"
0 comments:
Post a Comment
歡迎文章相關的留言喔~
Feel free to leave a message to me if you got any ideas regarding the topic I wrote about...if you just want to leave a general message, there is a guestbook at the left-side bar, please leave it there! :D
*If you don't have Blogger ID, you can choose [Name/URL] at the "comment as:" to leave a message to me...