Yes you can use UNC paths. Your current windows login id must have
permissions to access the UNC path, even though the package is in the server.
When you schedule the package in the server the SQL Service account must have
permisisons to access the UNC path.
Hope this helps.
--
Thanks & Rate the Postings.
-Ravi-
"Alex" wrote:
Quote:
Hi everyone,
I'm about to start working on exporting data to files within a DTS, but
since I'm editing the DTS on my workstation (not server) on Enterprise
Manager, the paths I'm using, are these on my computer or on the
server? Also is it possible to use UNC paths on the network? And if
so, what domain user does it use permissions for?
Thanks --
Sam |