Uproc executing some SQL command is aborting with the error messages below in the job log.
-------------------------------------------------
Access is denied.
The syntax of the command is incorrect.
-------------------------------------------------
Release : 6.x
Component : Dollar Unverse
Environmental issue
Based on the job log below, this could be related to a permission issue on the submission user SQL_Execution_Account. The SQL_Execution_Account is mapped to a domain user SBB01\bta .
-------------------------------------------------
Access is denied.
The syntax of the command is incorrect.
-------------------------------------------------
The above error message could be thrown out by one of the command below.
==================================================================
REM EDIT THE FULL PATH TO DTEXEC BIN IF IT'S NOT IN THE PATH
::set DTSCMDPATH="C:\Program Files\Microsoft SQL Server\100\DTS\Binn"
REM ** CHECK MANDATORY PARAMETERS **
if not defined DTEXECFILE goto :PARAM_MISSING
REM - OPTIONAL PARAMETERS
:: CONFIGFILE
:: EXTRA_OPTS
REM - FINE TUNE PARAMETERS
if defined CONFIGFILE set CONFIGFILE=/ConfigFile %CONFIGFILE%
set EXTRA_OPTS=%EXTRA_OPTS% /MaxConcurrent -1 /CheckPointing off /Reporting V
==================================================================
Troubleshooting steps:
-Check if there's any change on the SBB01\bta in terms permission and access policies
-Execute the same script outside $U with user SBB01\bta
-Check if there's any error message in the Windows Event Viewer