microsoft must have found some solution to resolve this problem

i have tried this too

copyalldefaults is set TRUE

but still it doesn't copy defaults....

yes i have SP2 installed

problem solved!!!!

Create new CREDENTIAL and Proxy for SSIS package and use this proxy instead of sql server agent account..

well i have gone through job histroy... it always says "

Message

The job failed. The Job was invoked by User sa. The last step to run was step 1...

thanks for reply

I m checking database integrity through the SSIS package

Its simple job. It works well within SSIS but when i run it from sql server agent then it gives...

thanks

its working now

problem was with sql server 2005 service packs. after installing service pack 1 for sql server 2005 its working fine..

thanks for reply.

setting dropobjectsfirst doesn't work, i had already tried it.

My main problem is with SA account login authentication. It always gives error "cannot apply value null to property login"

i...