create a data flow task

drag in a ole-db ado.net source connector, up to you which

drag in an excel destination connector

create the connection strings in both of the connectors to the database and to the excel file

set the source connector to run the stored proc

drag the line between the two connectors

run the package.