I am building an automation script using ToadDataPoint replacement variables. When I try to use an Execute Script and publish to TIC I get an error saying there are undefined variables. How can I use a combination of TDP replacement vars and publish to TIC. Or what is supported? I can use this script to save to LS so why can't I use the script to publish>
Here is the SQL Im using that seems to be the problem.
use ReportDatabase
-- Use this declarations when it runs in Automation Script
DECLARE @LedDate DATE = '#ReportDate#'
DECLARE @OfficeCode nvarchar(3) = CAST('#Loop_data_1_SQL.OfficeID#' as nvarchar)