/ExtractISPAC_fromSSISDB.ps1
Created May 4, 2019
Extract an .ISPAC from an SSIS Catalog and write to disk via SSIS PowerShell Provider
| <# This is the SSIS Project once it's deployed #> | |
| $Proj = Get-Item 'SQLSERVER:\SSIS\localhost\SQL2017\Catalogs\SSISDB\Folders\ProviderSolution\Projects\TestSSISProject' | |
| $Proj | Get-Member -MemberType Methods | |
| <# This is the theory I have #> | |
| [byte[]] $ProjBytes = $Proj.GetProjectBytes() | |
| [System.IO.File]::WriteAllBytes('C:\temp\ASSISPrj.ispac',$ProjBytes) | |
| <# Dont run this piece of code, you will hate me. #> | |
| $Proj.GetProjectBytes() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment