Where cause error issue at loading time

[Anonymous]

Where EmployeeName='D'souza';

[Gysbert_Wassenaar]

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)';