parse SQL failed in Data source with = or "
Hi, I'm creating data source with JDBC or Data connection. Recently I got a parsing error because of using SQL function with =. For example, the following query will fail by =. select IIF...
Forum Discussion
Hi, I noticed that if I add properties by manual, then the task just passed.
It fails when you try to rebuild with 'Build Query' wizard.
It fails when you try to rebuild with 'Build Query' wizard.
Select IIF(Injury= 1, 'Yes','No') as Test
From
dbo.Injury Where PatentID= 1
