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