FileDecrypt

Decrypts a single File

Stored Procedure
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

EXEC SQLHTTP.net.FileDecrypt @SourceFilePath, @DestinationFilePath, @SecretKey

Arguments:

Name	Type	Description
@SourceFilePath	varchar(MAX)	Full path to the existing source file
@DestinationFilePath	varchar(MAX)	Full path to the non-existing destination file
@Secret Key	nvarchar(MAX)	Case sensitive password



Remarks:

Accessing the file system will be performed in the context of the SQL Server instance process. You can set SQL Server to run using a specific network account, or a Local System Account.



Sample Usage:


DECLARE @SourceFilePath varchar(MAX)
DECLARE @DestinationFilePath varchar(MAX)
DECLARE @SecretKey nvarchar(MAX)

--Assign a path to a file that the executing user has read permissions on
SET @SourceFilePath = 'C:\ThisFolderExists\ThisFileExists.pdf'

--Assign a path to a file that the executing user has write permissions on
SET @DestinationFilePath = 'C:\ThisFolderExists\ThisFileDoesNotExist.pdf'

SET @SecretKey = 'This can be a very long password'

EXEC SQLHTTP.net.FileDecrypt @SourceFilePath, @DestinationFilePath, @SecretKey

DECLARE @SourceFilePath varchar(MAX)

DECLARE @DestinationFilePath varchar(MAX)

DECLARE @SecretKey nvarchar(MAX)

--Assign a path to a file that the executing user has read permissions on

SET @SourceFilePath = 'C:\ThisFolderExists\ThisFileExists.pdf'

--Assign a path to a file that the executing user has write permissions on

SET @DestinationFilePath = 'C:\ThisFolderExists\ThisFileDoesNotExist.pdf'

SET @SecretKey = 'This can be a very long password'

EXEC SQLHTTP.net.FileDecrypt @SourceFilePath, @DestinationFilePath, @SecretKey

Command(s) completed successfully.



FileDecrypt

Featured API Wrapper Code / SQL Server