You can set up an ExecuteSQLTask. Put the call your sp as :
exec testing.dbo.proc_TEmptest ?,?
(The '?' are the place holders)Now map these two question marks to the SSIS variables in your package by going to the parameters tab in the ExecuteSQLTask.