Hi Rick

Thank you kindly for your suggestion.  I kept on searching and found the following solution using visual basic in ETL script:

https://msbiblog.wordpress.com/2009/05/19/run-and-export-ssrs-reports-from-ssis-sql-server-2005/

I have developed a solution based on...