Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $cmdExport = New-Object System.Data.SqlClient.SqlCommand
- $cmdExport.Connection = $catalogDbConnection # Open connection to SSISDB
- $cmdExport.CommandText = "[catalog].[get_project]"
- $cmdExport.Parameters.AddWithValue("@folder", "<your SSIS Folder Name>") | Out-Null
- $cmdExport.Parameters.AddWithValue("@project", "<your SSIS Project Name") | Out-Null
- # Use ExecuteScalar() method to get a cursor to read varbinary(MAX) return.
- $bReader = $sqlCommand.ExecuteScalar()
- # WRITING OUTPUT
- # Use the WriteAllBytes static method on the .NET System.IO.File class
- # for writing bytes to disk at provided path.
- # Cast varbinary(MAX) query return to byte[] array to use as function argument.
- [System.IO.File]::WriteAllBytes("SsisPackage.zip", [byte[]]$bReader) | Out-Null
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement