I am trying to dump data from SQL Server into an Excel file. I want to dump the file to the 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 erver. 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?

If you are using active directory, go to the services account
--->open properties
--->select account
--->logon to
--->then add the server

Usually such account does have permission to access all servers on the network.