Return
-
Title
Automation fails with the 'Select to File' activity, it the driving query contains a '&' symbol -
Description
The "Select to File" activity exports the data for each row into an Excel file. However, if one of the rows of the driving query contains an "&" symbol, the automation fails when that row is processed. The following error appears:
'AutomationNotWorking.log: File_1 - '"' is an unexpected token. The expected token is ';'. Line 27, position 22.' -
Resolution
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Toad for SQL Server