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.

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

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