How to use PGP decryption in DTS package?

Hi,

Every day we will receive orderfiles which are PGP encrypted. I will download them from a FTP server using an FTP scheduler and then import them into our database using a dts package.

I want to include the PGP decryption in the DTS package.

I suppose it should be possible to use a PGP commandline tool to decrypt the file and call this tool from a SQL TASK using the xp_cmdhell? Does anyone know a link to an example? And which PGP commandline tool would you recommend?

Or are there simpler ways to accomplish this task?

Thanks,

DreadyStart Free Trial