SQL Server 2017
I am having trouble with an execute sql task.
The sql statement is
exec Integration_RetrieveMessageToProcess ?, ?, Billed
I have tried surrounding Billed with no single quotes, single single quotes, double single quotes and putting Billed into a variable and passing as a parameter. Every time the emitted sql has incorrect single quotes as seen by profiler. Here is an example:
exec sp_executesql N'exec Integration_RetrieveMessageToProcess @P1, @P2, Billed''',N'@P1 float,@P2 float',525,1
Any idea how to do this?