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'
.png)

.png)
.png)