ÿþ<html> <head> <title>Set-ISConnectionString</title> </head> <body> <h1>Set-ISConnectionString</h1> <div>Sets the Connection Manager data source to the specified SQL Server.</div> <h2> Syntax </h2> <code>Set-ISConnectionString [-package] &lt;Object&gt; [-connnectionInfo] &lt;Hashtable&gt; [&lt;CommonParameters&gt;]</code> <h2> Detailed Description </h2> <div> The Set-ISConnectionString function sets the Connection Manager data source to the specified SQL Server. </div> <h2> Related Commands </h2> <div> * <a href='Set-ISConnectionString.htm'>Set-ISConnectionString</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>package&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>connnectionInfo&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 Set-ISConnectionString.</div> <h2> Return Values </h2> <div>None This function does not generate any output.</div> <h2> Examples </h2> <h3> EXAMPLE 1</h3> <pre>$package = Get-ISPackage 'msdb\sqlpsx2' Z002</pre> <div>Set-ISConnectionString $package @{SSISCONFIG='.\SQL2K8'} This command gets the SSIS package sqlpsx and sets the data source to '.\SQL2K8' for the Connection Manager SSISCONFIG.</div> </body> </html>