說明如何利用 Visual Studio Release Management自動化佈署SSIS Packages?
要將SSIS Package 利用Release Management for Visual Studio 自動化佈署
原則上只要建立一個元件 利用PowerShell 呼叫 Integration Services Deployment Wizard 即可
如下例:
C:\Program Files\Microsoft SQL Server\120\DTS\Binn\ISDeploymentWizard.exe”
/Silent /SourcePath:“<project path>\DeploymentPOC.ispac”
/DestinationServer:“localhost”
/DestinationPath:“/SSISDB/<project folder>/DeploymentPOC”
參考網址:
風來疏竹，風過而竹不留聲；雁度寒潭，雁去而潭不留影。故君子事來而心始現，事去而心隨空。
