I've a package variable "varmodby" which is a string datatype and value =Update_Table_name
that I want to feed into a stored procedure without directly assiging the value to storedprocedure.
Below is storedprocedure
declare @p_PCount int,
@p_FCount int
Exec [dbo].[usp_Process]'Update_Table_name',1,
@p_PCount output,
@p_FCount output
select @p_PCount, @p_FCount
Please help.