Error in Load Data

[Vivek12]

Hey folks!

I have a script to fetch data from SQL connection. 

The script is running fine in one app while the same script is showing following error in the other app (duplicate of the first one)

Error- 

The following error occurred:

(Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [42000] Incorrect syntax near 'Unqualify'., "))

Can anyone help me on this?

What could be the potential issues over here?

[marcus_sommer · Accepted solution]

It looked that you don't compare an equally script else just parts from them which is in general not valide.

Beside of this it seems that the error is caused from the qualifying, see:

(Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [42000] Incorrect syntax near 'Unqualify'., "))

I suggest to remove all qualifying because it creates no added value and therefore only more efforts and risks remain - therefore why using it ...