Disconnect-SsisdbSql

NAME Disconnect-SsisdbSql



SYNOPSIS

dispose of a connection to sql instance





SYNTAX

Disconnect-SsisdbSql [-sqlConnection] <SqlConnection> [<CommonParameters>]





DESCRIPTION

Using sqldataclient.sqlconnection, dispose a connection to sql instance

Dispose method also calls close, so it return connection back to the pool

State of conection can be open, closed, broken, connecting, executing, fetching





PARAMETERS

-sqlConnection <SqlConnection>

The connection we wish to dispose of.



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:\\>$mySqlConnection = "Server=.;Integrated Security=True"



Disconnect-SsisdbSql -sqlConnection $mySqlConnection











RELATED LINKS