July 5, 2007 at 2:50 am
what and how security can be done, the possible best method to secure the csv file which is been ftp.
is there any other way secured way to transfer the file without doing a ftp.
July 5, 2007 at 3:04 am
With proper permissions and firewall settings FTP would be ok else think for other solutions.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 5, 2007 at 3:09 am
dont want to send the file through ftp but want to tranfer the file through some other secured way. pls suggest some other method
July 5, 2007 at 5:09 am
You want the transfer the object within the network or outside. Whats the size of the file that you want to transfer.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 5, 2007 at 6:41 pm
outside the network with lot of security, dont know the size of the file yet.
thanks
July 5, 2007 at 11:53 pm
Jai -
FTP is inherently insecure and has been replaced by SFTP (secure FTP) where security of the transmitted files is important.
There are a variety of SFTP clients and SFTP servers available. Note that there is not a SFTP component for DTS out of the box though one may be available from a third party - I'm aware of one for SSIS but have never looked for one for use with DTS.
Joe
July 6, 2007 at 12:17 am
Thanks joe.pls give more info abt SFTP.
July 6, 2007 at 12:59 am
Jai -
Just search for "SFTP client" or "SFTP server" on google... basically SFTP is an upgrade of FTP to include encryption of the connection between the client and server - you need a SFTP server and an SFTP client.
Joe
July 6, 2007 at 2:16 am
ya!!! great boss
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply