Get-ISPackage

Gets the SSIS package at the specified location.

Syntax

Get-ISPackage [-path] <String> [[-serverName] <String>] [<CommonParameters>]

Detailed Description

The Get-ISPackage function gets the SSIS package at the specified location. Both SQL Server and File System stored packages are supported.

Related Commands

* Get-ISPackage

Parameters

Name Description Required? Pipeline Input Default Value
path    true  false   
serverName    false  false   

Input Type

None You cannot pipe objects to Get-ISPackage.

Return Values

Microsoft.SqlServer.Dts.Runtime.Package Get-ISPackage returns a Microsoft.SqlServer.Dts.Runtime.Package object.

Examples

EXAMPLE 1

$package = get-ispackage -path "C:\Program Files\Microsoft SQL Server\100\DTS\Packages\sqlpsx1.dtsx"
This command gets the package sqlpsx1.dtsx from the file systems and assigns it to the variable $package.