Encrypting files using PGP in SQL

[richrich05]

Hi All,


I'm totally lost where to start. i need to start encrypting files sent daily to my supplier. I currently have a DTS that controls the creation and transfer of the file. How do i encrypt a file using SQL 2000 instances?

 

[TysonLPrice]

I don't think you can natively but this link is to a COM wrapper that looks promising.

http://www.planet-source-code.com/URLSEO/vb/scripts/ShowCode!asp/txtCodeId!1268/lngWid!5/anyname.htm

 

[mrdenny]

Correct, there is no native way to handle this. A third party solution would be required. You can run the PGP app from a command line object in your DTS package to encrypt the file after it has been created.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[compuveg]

I would look into the xp_cmdshell command that lets you run command line utilities. Once you get the hang of that, install a DOS/text mode PGP engine that can be called through that.

I think the ability to execute command line items is deprecated in 2008.

The COM wrappper's probably easiest.

 

[richrich05]

Thanks all for the advise. I've started playing with open pgp and think that i'll use that for my PGP encryption needs.

 

[mrdenny]

xp_cmdshell hasn't been deprecated. However enabling it is not recommended as it is a security risk.

As you are doing this in DTS already, you don't need to use xp_cmdshell. DTS has a command line object that should be used.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog