In all three files, I added a little extra code in order to display more information while executing. SSIS Package name you want to have it stored. SSIS SQL Servername where the SSIS package with be stored.Ĭ. Package Source location with the filename.ī. One PowerShell Script file “ SSIS_Deploy_PckgUtil.ps1” – This script will run from the console prompting you for three information:Ī. Two DOS batch files: SSIS_Deploy_PckgUtil_2K5.bat and SSIS_Deploy_PckgUtil_2K8.bat – Each of these batch file will deploy your SSIS package to an specific SQL Server version.Ģ. Using my PrimalScript 2009 editor I end up creating three script files:ġ. Without going into too much detail, it was tricky for me to put this together. *Note: For more information click this link “DTUtil Utility”: Implementing DTUtil to run from PowerShell In this sample, my SSIS package location is the default MSDB folder.ĭtutil /FILE c:\sourcepkg.dtsx /DestServer /COPY SQL destpkgnameĭtutil /FILE c:\sourcepkg.dtsx /DestServer /COPY SQL destlocation/ destpkgname
If is needed, remember to create the SSIS folder where your package is going to be deployed. If you don’t identify the properly the DTUtil.exe then it will pick the first on from the system path:Įxample of DOS environment PATH setting: (highlighted in yellow the SQL 2k5 & 2k8 Binn path)ģ. For SQL Server 2008 – “C:\’Program Files’\’Microsoft SQL Server’\100\DTS\Binn\dtutil.exe”Ģ. For SQL Server 2005 – “C:\’Program Files’\’Microsoft SQL Server’\90\DTS\Binn\dtutil.exe”ī. Make sure to identify the full path to run DTUtil.exe because you may have both SQL Server 20 on the same box:Ī.
#Sapien powershell studio popup messagebox how to
So, let me provide some pointers on how to use PowerShell to Deploy SSIS packages:ġ. The reality is, that DOS will stay around for awhile and there’s nothing we can do about it.
Well, this is a good example that sometimes you have to add extra code in other to use PowerShell to execute a DOS command. I will demo the integration of this function into your Visual Studio environment.
This script will continue to evolve to a PowerShell function. I’m showing my initial script to deploy an SSIS package.
0 kommentar(er)
