Hi everyone,

I'm developing an Ensemble process that sends user data from a Business Process to a Business Operation using EnsLib.SQL.OutboundAdapter. The operation is supposed to call a stored procedure on a SQL Server.

The stored procedure expects 3 parameters:
@FirstName, @LastName, and @Email.

The procedure works fine when executed directly from SQL Server Management Studio.

However, when I trigger it via Ensemble, I get the following error:

[SQL Server] Incorrect syntax near 'email@domain.com'

hat is the proper way to use ExecuteProcedure or ExecuteUpdateParmArray to safely pass parameters to a SQL Server stored procedure using EnsLib.SQL.OutboundAdapter?

If anyone has a working example of a Business Operation calling a SP with parameters – that would be a huge help 🙏

Thanks in advance!