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

* Set-ISConnectionString

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.