Re: Isssues Running .sql from SQL Task of ANT

2008-05-11 Thread Andrew Goktepe
If you are running Ant 1.7.0 try expandproperties="false" on . I'm not sure this works when running a separate sql file but it is worth a try. Otherwise I would try escaping the [EMAIL PROTECTED] with double $s and maybe double @s as well: $${@@colindex.0} I haven't tested either of these but t

Isssues Running .sql from SQL Task of ANT

2008-05-08 Thread Kothari, Shivani
Hi, I am executing .sql which has procedure with [EMAIL PROTECTED] . This .sql is executed from SQL Task through ANT scripts. This .sql file having procedure is runnin properly form sql server studio. Statements in SQL procedure : SET @PLOT_LINK = 'openForm("ESD_ADM032_FRM_AUTO_ROUTING&look_u