Where cause error issue at loading time

Anonymous — Sun, 09 May 2021 07:50:04 GMT

Where EmployeeName='D'souza';

Re: Where cause error issue at loading time

Gysbert_Wassenaar — Sun, 09 May 2021 08:21:23 GMT

The single quote in the name is causing the problem. Try adding an extra single quote to 'escape' it:

Where EmployeeName='D''souza';

Another thing you can try is using a variable:

SET vEmployeeName = D'souza;

Load Stuff From SomeTable Where EmployeeName = '$(vEmployeeName)';