USP_SFTPFINDERSERVICESCONFIGURATION_GET

Parameters

Parameter	Parameter Type	Mode
@USERNAME	nvarchar(100)	INOUT
@PASSWORD	nvarchar(100)	INOUT
@URL	nvarchar(255)	INOUT
@PORT	int	INOUT

Definition

Copy



            CREATE procedure dbo.USP_SFTPFINDERSERVICESCONFIGURATION_GET
            (
                 @USERNAME nvarchar(100) = null output,
                 @PASSWORD nvarchar(100) = null output,
                 @URL nvarchar(255) = null output,
                 @PORT integer = null output
            )
            as
            begin
                set nocount on;
                exec dbo.USP_GET_KEY_ACCESS;

                begin try
                    select top 1
                        @USERNAME = USERNAME,
                        @PASSWORD = convert(nvarchar(100), DecryptByKey(PASSWORD)),
                        @URL = URL,
                        @PORT = PORT
                    from dbo.SFTPFINDERSERVICESCONFIGURATION;

                    close symmetric key sym_BBInfinity;
                end try
                begin catch
                    close symmetric key sym_BBInfinity;
                end catch
            end