04-02-2018 02:56 PM
I have a DI Studio job with a User Written transformation where I'm calling a SQL stored procedure. I need to pass today's date to the stored procedure. My code is giving me this error:
ERROR: CLI execute error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'convert'.
Here is the code:
connect to odbc ("dsn=SQL server Xxx; Trusted_Connection=yes; database=Xxxxxx");
execute (CCR_Rpt.spUpdate_Pers_Pref_Report @RunDate = convert(date, getdate())) by odbc;
What do I need to do to correctly pass today's date to the stored procedure?
Thank you for your help!
DI Studio 4.9
04-02-2018 03:41 PM
04-02-2018 04:03 PM
Linus - I have called several SPs via SAS successfully. This is the first time trying to use today's date for the parameter.