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
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.