Filr Transfer

[gsavitha]

Dear All,

I scheduled a daily report using SSRS and it is now stored in local server.But i need to automate and send this
file to another server using SFTP.How to do this.Any help regarding this is highly appreciated.
Many Thanks.

Regards,
SG

 

[simian336]

Assuming that it is regular ftp and not secure ftp.

Easiest way is just use DOS FTP command from the sql server Execute command.

You could also do it with the FTP object in SSIS.

Simi

 

[simian336]

Sorry missed the SFTP part, it ran together.

One free tool is WinSCP and is has a dos mode that you can script.

Run it with execute.

Simi

 

[fredericofonseca]

winscp or putty sftp are two of the most common tools used. search for examples of how to use it on the net within ssis. its easy enough

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886