When you run the SQL Adapter inside Visual Studio, it builds a schema that allows you to map to the parms of the stored proc.
I find it easier if the stored proc returns at least one row, even if it is a \”Select return-code\” or something like that. You then do a Send to an Send Port (Request/Response with SQL Adapter) followed by a receive inside the orchestration.
I have an entire CD dedicated to SQL – see below.