Use a Stored Procedure to update a Table
I have a DTS files that is used to flag records as "Integrated". The source pulls recently integrated batches from the accounting system. The destination then uses an update to look up a batch number and if found then updates an "integrated" field in the system of origin. This is a fairly common practice with Scribe.
With that in mind, the source or database of origin is now changing and the location and structure of the tables and "Integrated" field is a bit more complicated.
Rather than do a table update via scribe the owner of the database would like us to use an existing stored procedure, essentially passing the batch id parameter to the SP and allowing the SP to do the update. Is this possible with Scribe and if so any suggestions as to how it could be setup? Please advise. Thank you.