I solved the issue by creating a user variable and putting Z:\Gis\SCAN DRAWINGS\ as the value. The expression will accept the user variable and my package runs as intended. Thanks...
Tried that and i am still getting the error message....
Error at Data Flow Task [Derived Column [215]]: Attempt to parse the expression "(LTRIM([drawing e-location])== "Z:\\Gis\\SCAN DRAWINGS\\"" failed. The expression might...