Error using the Microsoft SQL Stored Procedure Destination
By David Youngquist, Senior Support EngineerThursday, November 8, 2012
Running a SmartConnect map using the SQL Stored Procedure Destination. Receiving an error that says ‘The selected stored procedure does not meet the requirements. Please see more details.’ The detail section says:
The stored procedure requires both of the following out parameters: 1. varchar(255) 2. int.
For a stored procedure to be used by SmartConnect it must have at least two output parameters, and integer and a varchar.
The first integer output parameter is checked to determine the success of the call. If the integer is 0 the process is considered successful. Anything else and the process is considered to have failed.
The first varchar output parameter is checked to determine any error messages. This message will be displayed to the SmartConnect user if the stored procedure is deemed to have failed.
Note: if this is an eConnect type store procedure with the validation messages stored in the eConnect tables this parameter should return the number of the eConnect message to be displayed as a varchar.