December 20, 2007 at 1:25 pm
I am trying to run PGP command line from SSIS
The following command is working from DOS prompt
"C:\Program Files\PGP Corporation\PGP Command Line\pgp.exe" --decrypt "\\Server\Folder\File.zip.pgp" --passphrase "passphrase" --output "\\Server\Folder\File.zip" --overwrite remove
But in SSIS if I put the argument (whatever after pgp.exe) in SSIS, SSIS wraps the argument with double quotes and make the entire command invalid.
Am I using it correctly? or is there a different way to put an argument?
thank you.
December 20, 2007 at 6:36 pm
Max, you didn't specify but I assume that you are using the Execute Task item to run this executable? If so, you should be able to put the entire argument into the Arguments property of the Execute Task object.
hth,
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
December 21, 2007 at 12:09 pm
If your executing this through expressiong you need to ensure that double your quotes or it will throw a syntax error. So UNC path of \\servername\mydir\myfile.txt would actually need to look like this.
"\\\\servername\\mydir\\myfile.txt"
SSIS uses "\" as a reserved command...for what I am not sure. Just know that is the way they designed it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply