There are two possible solutions to this issue:
1.  Create stored procedure manually in SQL Server
2.  Create a second stored procedure spec with code and load separately