USP_IMPORTSOURCE_GET
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @IMPORTSOURCEID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_IMPORTSOURCE_GET(@IMPORTSOURCEID uniqueidentifier)
as
set nocount on;
-- Open the symmetric key for decryption
exec dbo.USP_GET_KEY_ACCESS;
select NAME, URLORPATH, PORT, IMPERSONATE, USERNAME, convert(nvarchar(200), DecryptByKey(PASSWORD)) PASSWORD, IMPORTSOURCETYPECODE from dbo.IMPORTSOURCE where ID = @IMPORTSOURCEID;
close symmetric key sym_BBInfinity;