Execute Sql Task

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

July 24th, 2015 3:39am

Hi,

It is straight forward, same as you would have executed the sp in SSMS:

EXEC sp_UPDATE_MY_TABLE
What are you stuck at actually?
https://technet.microsoft.com/en-us/library/ms141003.aspx
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2015 3:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics