November 19, 2004 at 4:35 pm
I have a package that runs an activex script which is reading and writing to a network drive, however if I run the task manually it works fine but if I schedule it then it fails with Path Not Found. I'm guessing this is a rights issue and to add extra headaches, the network drive is on an AS/400.
Hopefully someone can shed some light with an easy fix.
November 19, 2004 at 5:35 pm
There have been several AS/400 DTS questions posted here.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=144677
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=145080
http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=139274
or check out the results from goole for others.
http://www.google.com/search?hl=en&q=%28%22as%2F400%22+or+%22as400%22%29+site%3Asqlservercentral.com
November 19, 2004 at 9:21 pm
Thanks very much Antares686, those links confirmed my suspicions and hopefully the methods are going to work. I managed to get it going to a domain drive but haven't tried with the as/400 because we don't have the client access installed on the sql box, I was hoping to not have to do that but...
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply