I like Kemps answer (reads easier). Is your problem not maybe somewhere else, like the city field is blank? Try excluding portions of your query to prove it.
If you are running the DTS package as a job, your SQL agent needs access to the operating system file. That means your sql agent must be started with...