Error Opening Data File:Login Failure:Invalid User or Bad Password -
07-25-2006
, 05:04 AM
I've read the link on How to Run a DTS Package as a Schedule Job but I really
can't find the caus
This package failed when scheduled with the error in the Subject Line. But
I had no problem manually executing it.
The package's owner is the same as both the SQL server and SQL server agent
start up account. I have even ticked all the server roles including SYsadmin
for this account to no avail...
The path has also changed from map to using UNC..
This package 's task is to write a file on another server. Othe package can
schedule ok(mainly transferring files b/w SQL servers).
What else can I look out for ? should I turn and focus on the rights and
permisson on between the server..but then I could write successfully when
manual run paackge...
Can someone kindly advise me .. I'm getting demoralised to get stuck on this..
Thanks a lot in advance.. |