Set-ISConnectionString
Sets the Connection Manager data source to the specified SQL Server.
Syntax
Set-ISConnectionString [-package] <Object> [-connnectionInfo] <Hashtable> [<CommonParameters>]
Detailed Description
The Set-ISConnectionString function sets the Connection Manager data source to the specified SQL Server.
Related Commands
Parameters
Name |
Description |
Required? |
Pipeline Input |
Default Value |
package |
|
true |
false |
|
connnectionInfo |
|
true |
false |
|
Input Type
None
You cannot pipe objects to Set-ISConnectionString.
Return Values
None
This function does not generate any output.
Examples
EXAMPLE 1
$package = Get-ISPackage 'msdb\sqlpsx2' Z002
Set-ISConnectionString $package @{SSISCONFIG='.\SQL2K8'}
This command gets the SSIS package sqlpsx and sets the data source to '.\SQL2K8' for the Connection Manager SSISCONFIG.