One way would be to have a stored procedure that the SSRS report accesses. In the stored proc, you could include the instruction to execute the required package, using master.sys.xp_cmdshell.

However, care must be exercised that no passwords are included in the command, as this is stored in plain text