When you run DTS manually from your machine you are using your security.  When it is scheduled you are running SQL Agent security.  If you are importing text files or...