Hi ,
Can anyone please tell how we can use a stored procedure inside a execte sql task
I have stored proc with one input parameter and the execute sql task I have declare the parameter .
I have geiven the below code in the execute sql task
exec DATA_COMPARE ?
Data_comapre is my stored procedure name and I am getting syntax error . How we can call sp from execute sql task
Thanks
Jeeva