Set-ISPackage
Writes or replaces the SSIS package with a new package.
Syntax
Set-ISPackage [-package] <Object> [-path] <String> [[-serverName] <String>] [[-force]] [<CommonParameters>]
Detailed Description
The Set-ISPackage function writes or replaces the SSIS package with a new package. Both SQL Server and File System storage are supported.
Related Commands
Parameters
Name |
Description |
Required? |
Pipeline Input |
Default Value |
package |
|
true |
false |
|
path |
|
true |
false |
|
serverName |
|
false |
false |
|
force |
|
false |
false |
|
Input Type
None
You cannot pipe objects to Set-ISPackage.
Return Values
Microsoft.SqlServer.Dts.Runtime.Package
Get-ISPackage returns a Microsoft.SqlServer.Dts.Runtime.Package object.
Examples
EXAMPLE 1
$package = Get-ISPackage 'msdb\sqlpsx2' Z003
Set-ISPackage -package $package -path '\msdb' -serverName Z002
This command gets teh SSIS package sqlpsx2 from the SSIS server Z003 and saves the package to the SSIS server Z002.