mp83399 (8/28/2012)
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.
I sure hope the OP solved his problem 2 years ago 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP