July 7, 2008 at 4:38 pm
I have data being transferred using dts(or ssis) packages and I need to secure the data during the transfer. My thought was to put an SSL on the domain hosting the destination server but MS has said that it is not a reliable security measure. What do you all suggest for securing this data?
Thanks for your assistance!
Mitch
July 7, 2008 at 11:10 pm
Secure FTP would work, though I'm not sure how that would integrate with SSIS.
Perhaps Secure tunneling at the network level? There's a secure TCP/IP connection method that you can setup in Windows.
July 8, 2008 at 5:45 am
A lot of it can depend on what technology you have on-hand and what type of data transfer you are doing.
For example, if you are transferring data from one SQL Server to another, you could set up a VPN tunnel between the two. If you are retrieving files, you could PGP encrypt them before they are sent and decrypt them when they get to you.
If you give some specifics, there are other options available.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply