CODEWITHSUNDEEP
.netencryptionssisscriptingpgp
Bantu11
Bantu11

Reputation: 43

How to do PGP encryption/decryption of a file using SSIS?

I am new to SSIS. I have a ask where data files needs to be sent over the network. Hence, those data files needs to PGP encrypted/decrypted, transformed and then decrypted/encrypt before sending, all using SSIS. Please suggest some way or reference for this. I looked over the net but could not find anything that can help me

Upvotes: 1

Views: 1643

Answers (1)

BeiBei ZHU
BeiBei ZHU

Reputation: 363

I have implement this before.

you need to build a PGP Dll(what I do it like this), and include this dll into Script task, inside script task encrypt and decrypt file. and also, you need to add this dll into GAC, otherwise SSIS can't find it.

Private and Public Key use Parameter to store.

Upvotes: 1

Related Questions