DTS error-- The system cannot find the file specified -- sql server dts

Lynn
5/31/2006 12:39:02 PM

Hi,

I am trying to setup an DTS for other region to run the loading job. From
that user's machine, I can expplor to that directorty (I even use
\\servername\path formoat) and open the file from command line or explore.

But, when I try to open that DTS from Enterprise Manager at that user's
machine, I got the package error

Error Source: Microsoft data Transformation Services (DTS) Package
Error Description: The system cannot find the file specified.

I don't know what's this error since I can explore to that file at that
machine.

Please help.

Lynn
--
Best Regards,

SP
5/31/2006 4:46:02 PM

My guess, This is a permission issue, you have the access to explore that
directory but the DTS package might be using some different account for whcih
it doesn't find the directory. Try and find if the administrator on server
machine on which you have the dts package has the permission to that shared
directory. You can log on to that server box remotely and try to explore the
directory and see if you can access it or not.

[quoted text, click to view]

Allan Mitchell
6/4/2006 11:09:10 PM

Hello Lynn,

Is this when opening the package itself?

if it is then maybe you are seeing this

http://support.microsoft.com/?kbid=274716

Allan

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : DTS error-- The system cannot find the file specified