Pre-/Post-SQL not executing
Using Scribe 7.9.1 and an ODBC defined SQL connection with SQL Auth, I cannot make the SQL Scripts defined in the pre and post DTS settings execute.
Security is correctly configured, as I can execute it manually using the same credentials or by adding the contents of the SQL script to the Source Query BEFORE the query that returns the data to transfer in the DTS.
Contents of the SQL Script:
DECLARE @RunDateTime DATETIME = CONVERT(VARCHAR, GETDATE(), 112);
EXEC DB01.dbo.spSomeName @dtmRunDate = @RunDateTime, @blnStoreDelta = 1;
Enabling trace yields nothing that remotely resembles the script name or the sp called from the script in the trace file. Nor is anything logged in the Execution log in the SCRIBEINTERNAL database.
Does anyone have a solution for this issue?