Attaching a SSRS Report to an email

 1 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Garry Ferwerda
Basic Member
Posts: 20
Basic Member
    Does any one know of a way to write a byte stream from ProcessFlow? I want to attach a SQL Server Reporting services report to an email. The report can be created by the flow using the webservices node. But what is returned by the node is byte stream that needs to be written to the file system. I have tried using the custom activities node with the encoding activity and the convertStringToASCIIBytes activity but haven't figured out how to right that to the file system. The file activity node writes the result of the custom activity node as string.

    Thanks,
    Robert
    Veteran Member
    Posts: 82
    Veteran Member

      Compelling problem.  I don't completely follow you here, are you attaching to the email or streaming content to it?

      You are using integrator right?  That should allow you harness any utility you want outside of the flow to achieve your objective.  If it is a true attachment writing the file to $LAWDIR/bpm/emailattachments should work.  If the file name is dynamic it complicates matters, but you can initially hardcode a filename to see if it works.  Then it is up to your email client to manage the attachment.