Send SQL Server Reporting Services Report through BizTalk

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Send SQL Server Reporting Services Report through BizTalk

Viewing 1 reply thread
  • Author
    Posts
    • #22638

      Hi all,

      I am having a flat file, I need to read that file, process the data and import into SQL Server. Then using SQL Server Reporting Services, I need to create a Report. This report I need to send, through the Send port of Biztalk as an email attachment.

      I have already read the flat file, processed it and imported into DataBase. I have also created an SQL Server report for the data.

      Can anyone please guide me about how to send this report as an email attachment. I know we are having SMTP adapter to send an email, but how can I dynamically attach the report and send it.

      Thanks and Regards,

      Kunal

    • #22641

      Hi Kunal,

      I am not sure do we have any facilities in BizTalk as per your requirement.

      Yeah but my suggestion Once you receive data from SQL Server you can generate PDF using .Net application and save it on local machine and after that get file from local machine and attached with you mail and send it to respective user using SMTP Send port.

      Hope my suggestion will work. [:)]

      Regards,

      – Dhaval M.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.