Elaborating on Ray's reply...
You could create an SSIS Package and then you could call that from the stored procedure, by various means... using XP_Cmdshell, usign TSQL to add it to a job in the SQL Agent que etc.
There are various articles on the very subject on this site. Another reference you could use would be BOL or SQLdts.com
-Luke.
To help us help you read this[/url]For better help with performance problems please read this[/url]