Integration using stored procedure and smartconnect

So you run your integration file which is using a stored procedure instead of a table.

Then you get error messages in the form of a number. You check Event Viewer and find nothing.

For example '7' or '50997'.

To figure out what this means you have to run the below select statement:

SELECT * FROM DYNAMICS..taErrorCode