I am trying to dump data from SQL Server via a DTS Package into an Excel file. I want to dump the file to a web server and have the user retrieve it via one of our web apps. Of course, in order to have the DTS package dump the data to the server, the SQL Server Service Account needs permission to access the web server. What is the best way to give SQL Server that permission. Is it just by right clicking on the folder and selecting Property, the clicking the Security tab?