Post reply

export SSRS report to client's secured FTP site. How to do this?

  • December 13, 2010 at 11:28 am

    #228476

    Hi,

    I have to export SSRS report to client's secured FTP site. How to do this?

    Any help?

    Thank you,

    BMR

  • December 15, 2010 at 6:58 am

    #1262813

    You can't do this all from within SSRS. First thing I would do is create a subscription to the report to create your file. Then use some programmable SFTP software to move the report to the destination. You may be able to purchase an SFTP Control Flow Task for SSIS, but I am not sure.

  • December 16, 2010 at 9:10 am

    #1263529

    Thanks for reply,

    BMR

  • April 28, 2011 at 4:39 pm

    #1317619

    Setup a subscription to shared folder (not email).

    Then use SSIS to first compress (zip) the file (say Excel) and then copy to FTP site folder.

    Have done this and it works.

  • August 5, 2023 at 7:51 pm

    #4253698

    Old post, I know.  But for future readers, this can be accomplished from SSRS using Deztec's SFTP Destination extension for SSRS.

Viewing 5 posts - 1 through 4 (of 4 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy