ÿþ<html> <head> <title>Get-ISSqlConfigurationItem</title> </head> <body> <h1>Get-ISSqlConfigurationItem</h1> <div>Gets the SSIS configuration items.</div> <h2> Syntax </h2> <code>Get-ISSqlConfigurationItem [-serverName] &lt;String&gt; [-databaseName] &lt;String&gt; [-configurationTable] &lt;String&gt; [-configurationFilter] &lt;String&gt; [-packagePath] &lt;String&gt; [&lt;CommonParameters&gt;]</code> <h2> Detailed Description </h2> <div> The Get-ISSqlConfigurationItem function gets the SSIS configuration items using a SQL Server table store. </div> <h2> Related Commands </h2> <div> * <a href='Get-ISSqlConfigurationItem.htm'>Get-ISSqlConfigurationItem</a><br/> </div> <h2> Parameters </h2> <table border='1'> <tr> <th>Name</th> <th>Description</th> <th>Required?</th> <th>Pipeline Input</th> <th>Default Value</th> </tr> <tr valign='top'> <td>serverName&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>databaseName&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>configurationTable&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>configurationFilter&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>packagePath&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> </table> <h2> Input Type </h2> <div>None You cannot pipe objects to Get-ISSqlConfigurationItem.</div> <h2> Return Values </h2> <div>System.Data.DataRow Get-ISSqlConfigurationItem returns a System.Data.DataRow object.</div> <h2> Examples </h2> <h3> EXAMPLE 1</h3> <pre>Get-ISSqlConfigurationItem 'Z002\SQL2K8' 'ssisconfig' '[SSIS Configurations]' 'sqlpsx_ssis' '\Package.Connections[Destination].Properties[ConnectionString]'</pre> <div>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.</div> </body> </html>