dbTalk Databases Forums  

Working with Directories in DTS -- Local or on Server ?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Working with Directories in DTS -- Local or on Server ? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alex
 
Posts: n/a

Default Working with Directories in DTS -- Local or on Server ? - 07-01-2005 , 08:15 AM






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


Reply With Quote
  #2  
Old   
Ravi
 
Posts: n/a

Default RE: Working with Directories in DTS -- Local or on Server ? - 07-01-2005 , 09:37 AM






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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.