Post reply

secure ftp from sql server 2005

  • August 22, 2012 at 4:25 am

    #266390

    Hi all,

    Is there a way that can do secure ftp using sql server 2005? I need to secure ftp to some server and pull a file. It would be best to do it using T-SQL, if not, any other way?

    Actually I already googled a bit and below is my results, I have no experience with CLR, some experience with SSIS. I would like to here your suggestions regarding these two approaches or any other way?

    1. using SSIS with third party component. SSIS is integrated ETL tool of SQL Server 2005. It has a ftp component but it can only do FTP not secure ftp. But there are many third party components developed for SSIS that can do SFTP. SSIS can use these third party components to achieve SFTP function. Then the SSIS task can be scheduled in SQL agent job.

    2. use CLR (common language runtime), which is using .NET code to extend the ability of SQL server. E.g. using .NET code to generate some class which can do SFTP job, then this can be integrated into SQL server as a stored procedure kind of thing. Then it can be called from within T-SQL code/stored procedure.

    Thank you,

    Nian

  • August 22, 2012 at 6:11 am

    #1528571

    personally I use a purchased copy of CoreFTP Pro($40 bucks) , which supports SFTP and other secure FTP protocols;

    I can call it from a command line, where i pass it the profile name i had set up, so the command line never has any passwords visible at all.

    the documentation for it is very easy to understand.

    the free version can't be called via command line, I believe.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 23, 2012 at 7:42 am

    #1529248

    Thanks for the reply. I will be able to do some test next week. We will see. Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply