Get-ISSqlConfigurationItem

Gets the SSIS configuration items.

Syntax

Get-ISSqlConfigurationItem [-serverName] <String> [-databaseName] <String> [-configurationTable] <String> [-configurationFilter] <String> [-packagePath] <String> [<CommonParameters>]

Detailed Description

The Get-ISSqlConfigurationItem function gets the SSIS configuration items using a SQL Server table store.

Related Commands

* Get-ISSqlConfigurationItem

Parameters

Name Description Required? Pipeline Input Default Value
serverName    true  false   
databaseName    true  false   
configurationTable    true  false   
configurationFilter    true  false   
packagePath    true  false   

Input Type

None You cannot pipe objects to Get-ISSqlConfigurationItem.

Return Values

System.Data.DataRow Get-ISSqlConfigurationItem returns a System.Data.DataRow object.

Examples

EXAMPLE 1

Get-ISSqlConfigurationItem 'Z002\SQL2K8' 'ssisconfig' '[SSIS Configurations]' 'sqlpsx_ssis' '\Package.Connections[Destination].Properties[ConnectionString]'
This command gets the configuration item sqlpsx_ssis from the table [SSIS Configurations] from the database ssisconfig on the SQL Server Z002\SQL2K8. Only rows matching the \Package.Connections[Destination].Properties[ConnectionString] are returned.