I created an import wizard that runs 5 queries against an Oracle database, and 1 against an AS400 iseries. The wizard works fine when running on its own, but when I add it into an automation script, I receive the following error:
Import_1 - [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token was not valid. Valid tokens: + - AS . (“Embedded Query” into “dept_db.dbo.dt_wr_task_tbl”)
The invalid token is a right facing arrow (which doesn’t show up in the example because I guess it is a different character set). Why would this not work in the automation script only?
Has anyone encountered this before?