This is the error message on the sql agent. Like I said the package works. But when I ran it in the agent, it didn't work.

SQl Agent:

Date12/22/2008 9:07:51 AM

LogJob History...