Connect-SsisdbSql

NAME Connect-SsisdbSql



SYNOPSIS

create a connection to sql instance





SYNTAX

Connect-SsisdbSql [-sqlConnectionString] <String> [<CommonParameters>]





DESCRIPTION

Using sqldataclient.sqlconnection, create a connection to sql instance

Set database to ssisdb

return connection





PARAMETERS

-sqlConnectionString <String>

The SQL Connection as a string that we use to make object SqlConnection



Required? true

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Connect-SsisdbSql -sqlConnectionString "Server=.;Integrated Security=True"















RELATED LINKS