Ohh yeah...it works without any problems !

Hi John

Yeah you are right, If I I run the SQLSERVERAGENT using 'Administrator' account then the DTS job runs fine.

Thanks a ton for your feedback. 🙂

Amit

Hey John

Thnks for the reply. Yes, I have tried the SQL service agent properties to look for the access rights. THe Job is scheduled by user 'sa'. Also the SQL...