USP_IMPORTPROCESSOPTIONS_GET

CREATE procedure dbo.USP_IMPORTPROCESSOPTIONS_GET
as
    set nocount on;

    -- Open the symmetric key for decryption

    exec dbo.USP_GET_KEY_ACCESS;

    --select IMPORTFILEPATH, IMPERSONATE, IMPERSONATEUSERNAME, convert(nvarchar(200), DecryptByKey(IMPERSONATEPASSWORD)) IMPERSONATEPASSWORD from dbo.IMPORTPROCESSOPTIONS;

  select 
    URLORPATH as IMPORTFILEPATH,
    IMPERSONATE,
    USERNAME as IMPERSONATEUSERNAME, 
    convert(nvarchar(200), DecryptByKey(PASSWORD)) as IMPERSONATEPASSWORD 
  from 
    dbo.IMPORTSOURCE 
  where 
    IMPORTSOURCETYPECODE = 1

    close symmetric key sym_BBInfinity;