Hi, I am trying to execute a store procedure within an ensemble operation to connect to aMsSQL database and I am having problem to pass the input arguments... I have tried several things but only one seems to work and it is not the ideal solution.
ADAPTER = "EnsLib.SQL.OutboundAdapter";
This is the code that works...as you can see the parameter is added to the sql query...not the best solution but the only that works at the moment.
SET SQLQuery = "EXEC [dbo].[xxxx] '" _ pRequest.RawContent _ "'"
SET tSC=..Adapter.ExecuteProcedure(,,SQLQuery,)