FTP files using SQL stored procedure

  • Ed Klichinsky

    SSC Veteran

    Points: 230

    Comments posted to this topic are about the item FTP files using SQL stored procedure

  • Hardik Turakhia

    SSC Eights!

    Points: 898

    Any suggestion on how to achieve the same without using cmdshell command?

  • Jeffrey Williams 3188

    SSC Guru

    Points: 88147

    Hardik Turakhia - Thursday, April 5, 2018 6:19 AM

    Any suggestion on how to achieve the same without using cmdshell command?

    I prefer using SSIS to output files from SQL Server - and in my SSIS packages I setup a process task that runs WinSCP to FTP the files when necessary.  You could use Powershell to get the data and FTP/SFTP - or any other scripting language in combination with SQLCMD and/or BCP to output the data from SQL Server.

    [font="Verdana"]Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster[/url]
    Managing Transaction Logs[/url]
    [/font]

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

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