i loged in as 'sa'.I changed the Protection level and it still fails.When changing Protection level do i have to rebuild the pakage and then run Agent job?

Thank you guys all for for your responds.

I used Export Data to create SSIS pakage.I saved (file system) then created a Agent job.But job fails.Here is the error message:

Message

Executed...

My SQL server database mail is not set up

I was running on 2008.Would that mather?

I followed your instructions ,but i got no email.

After executing this SP this is what i get:

Mail queued.

Am i missing something?

After executing the Sp this is what i get:

Mail queued.

Am i missing something?