October 14, 2007 at 11:56 am
Comments posted to this topic are about the item FTP files using SQL stored procedure
April 5, 2018 at 6:19 am
Any suggestion on how to achieve the same without using cmdshell command?
April 5, 2018 at 8:21 am
Hardik Turakhia - Thursday, April 5, 2018 6:19 AMAny 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.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply