I have created a batch file, which is using 7z command to encrypt and compress a file. The command in the batch file is
7za -TZIP a [outputfilepath] [filepath] -p[password]
I am able to run the batch file successfully from the command prompt, however when I try to execute the same file from the SQL Server using the xp_CMDShell, it gives me the following errors:
Can not open file
Access is denied.
...