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