Can you run the job to completion in the dts designer?

If not, you can determine which step is causing the problem by running them individually using the Right Click menu - execute step.