When I do CTRL L to verify my event code, I get errors that indicates  MSOLEDBSQL throws a SqlState 42000 OLE DB Driver for SQLServer Incorrect syntax near 'xxx' Yet, when I run this code connecting to this database, the code works, the imbedded sql...

Hi friends, I created a user event in my dw, and wrote a routine.  Today, I've been trying to add a conditional loop, but can't save the changes due to error C0031: Syntax Error.  The offending lines are the first IF statement and associated END IF ...