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
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”