Let me google that for you:
SQL Stored Procedures[
^] will tell you about stored procedures, including creating them.
And
stored procedure ssis script - Google Search[
^] will go into specifics of SSIS and SP's.
Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...
In future, please try to do at least basic research yourself, and not waste your time or ours.