June 23, 2011 at 5:36 pm
I have a package which generates a Flatfile(CSV). Then i need to upload it to the FTP server with the PGP Encryption.the end users will download the files from the FTP location
Can anyone help me on this?
June 24, 2011 at 2:23 am
I don't think there's built-in capacity for that, so you'll probably have to resort to a script task for that.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 6:13 am
I looked at some articles to use the script and i was thinking of any open sources to do that..
June 24, 2011 at 10:18 am
You'll likely have to resort to an open source command line like utility such as GnuPG or buy a component like CozyRoc's SSIS component. Although after reviewing their pricing I'm feeling more than a little unhappy. I looked around and found this: http://ssisextensions.codeplex.com/[/url]
Which looks kind of promising. I have not used this library though.
CEWII
June 25, 2011 at 12:05 am
I can vouch for GnuPG being solid. It's free unless you require the patented Idea algorithm in which case you'll need to buy a license for that.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 25, 2011 at 11:07 am
I am using SQL Server 2005
June 25, 2011 at 12:59 pm
http://ssisextensions.codeplex.com/ is 2008 only.
Cozy Roc has a 2005 component but I just looked at it and it appears as if it support OpenPGP only, i.e. it does not support Idea. Do you need to support Idea?
GnuPG is a command-line tool so will work with any app that can call things from a command line. It will support Idea but as I said you'll need to buy a license, and it was a huge PITA to incorporate support for it. I had to recompile the binary gpg.exe on a Windows platform with the Idea C-library because they do not provide it in the redist msi.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2011 at 4:01 pm
Cozy Roc has a 2005 component but I just looked at it and it appears as if it support OpenPGP only, i.e. it does not support Idea. Do you need to support Idea?
What do you mean by idea...
June 26, 2011 at 7:49 pm
From http://en.wikipedia.org/wiki/International_Data_Encryption_Algorithm:
IDEA was used in Pretty Good Privacy (PGP) v2.0, and was incorporated after the original cipher used in v1.0, BassOmatic, was found to be insecure.[2] IDEA is an optional algorithm in the OpenPGP standard.
Idea is a patented algorithm. Some PGP software support the IDEA algorithm in their products. One of the partners I dealt with at the time used a package from PGP Corporation to encrypt their files and they chose Idea so I was forced to support it.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2011 at 8:20 am
opc.three (6/25/2011)
http://ssisextensions.codeplex.com/ is 2008 only.Cozy Roc has a 2005 component but I just looked at it and it appears as if it support OpenPGP only, i.e. it does not support Idea. Do you need to support Idea?
GnuPG is a command-line tool so will work with any app that can call things from a command line. It will support Idea but as I said you'll need to buy a license, and it was a huge PITA to incorporate support for it. I had to recompile the binary gpg.exe on a Windows platform with the Idea C-library because they do not provide it in the redist msi.
While it would be a PITA I would think you could down-grade it by hand. I have done some development with custom task in SSIS and control-flow tasks are easier to do that with. It could be a simple copy-paste job. Data-flow, not so much.. While I like what CozyRoc is doing I'm thinking his pricing model is a problem, but thats me. Most of the vendors I have dealt with have a "suite" option that is usually pretty pricey but you get everything, and each or groupings of each for a more reasonable price. Although if you need more than 2-3 of the singles the suite looks good. But thats just me.
CEWII
June 27, 2011 at 10:16 am
Elliott Whitlow (6/27/2011)
opc.three (6/25/2011)
http://ssisextensions.codeplex.com/ is 2008 only.Cozy Roc has a 2005 component but I just looked at it and it appears as if it support OpenPGP only, i.e. it does not support Idea. Do you need to support Idea?
GnuPG is a command-line tool so will work with any app that can call things from a command line. It will support Idea but as I said you'll need to buy a license, and it was a huge PITA to incorporate support for it. I had to recompile the binary gpg.exe on a Windows platform with the Idea C-library because they do not provide it in the redist msi.
While it would be a PITA I would think you could down-grade it by hand. I have done some development with custom task in SSIS and control-flow tasks are easier to do that with. It could be a simple copy-paste job. Data-flow, not so much.. While I like what CozyRoc is doing I'm thinking his pricing model is a problem, but thats me. Most of the vendors I have dealt with have a "suite" option that is usually pretty pricey but you get everything, and each or groupings of each for a more reasonable price. Although if you need more than 2-3 of the singles the suite looks good. But thats just me.
CEWII
Not leaving SSIS for PGP tasks would be preferable. And I agree, downgrading would probably be an easy thing to do. Just for completeness, I did a quick search for Bouncy Castle, but could not see if they natively support Idea, or if support can be added. Do you know?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2011 at 10:35 am
I'm using GnuPG for encrypting files from SSIS 2005 before uploading them to an FTP site. I use a scripting object to call the command-line options I need.
Works great.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 27, 2011 at 11:12 am
opc.three (6/27/2011)
Not leaving SSIS for PGP tasks would be preferable. And I agree, downgrading would probably be an easy thing to do. Just for completeness, I did a quick search for Bouncy Castle, but could not see if they natively support Idea, or if support can be added. Do you know?
I just looked back through the posts, and the OP only asked about IDEA after you posted on it, and in that case he was asking what it was. I am therefore going to assume that IDEA support is not important to him if he doesn't know what it is.. I absolutely agree that popping out to a command line by its very nature sacrifices a lot of control that I would rather not lose.. But it does work and can be done.
The bouncy castle library looks fairly good, I was gonna take a look at that for some other things I wanted to do. The project builds for .NET FW 2 and I'm 99% sure the project is actually a VS2005 project. So I think there should be no problems with using it with SSIS 2005.
CEWII
June 27, 2011 at 11:52 am
Elliott Whitlow (6/27/2011)
opc.three (6/27/2011)
Not leaving SSIS for PGP tasks would be preferable. And I agree, downgrading would probably be an easy thing to do. Just for completeness, I did a quick search for Bouncy Castle, but could not see if they natively support Idea, or if support can be added. Do you know?I just looked back through the posts, and the OP only asked about IDEA after you posted on it, and in that case he was asking what it was. I am therefore going to assume that IDEA support is not important to him if he doesn't know what it is.. I absolutely agree that popping out to a command line by its very nature sacrifices a lot of control that I would rather not lose.. But it does work and can be done.
Agreed. It was not specifically for the benefit OP, but for me 😀 I would not implement the component as an Enterprise solution unless it could do Idea. If it could not, then I would stick with my current solution, gpg.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2011 at 11:58 am
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply