• 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.