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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
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