Hi
I have scenario where I need to Call an Storeprocedure in SQL task
Eg: Procedure Name Like Usp_ABCDEF 'Param1',Param2'
Part of Stored Procedure name is coming from Varible
Eg: @Entity='DEF' [@Entity is a variable for the task]
How to pass it in SQL statement of SQL Task
I have done like EXEC ('Usp_ABC'+? ? ?)
But Iam getting an error .
Kindly request to help me .