I am new to SQL server so please bare with me. I have excel files residing in a folder on my webserver. I want to set up a DTS package that will grab the excel files on the webserver and populate a table on my sql server(seperate machines). I have no problems when i try this process on the same machine but how can i transfer the files across a network? Thanks
Are you saying you are having problems when you do it across the network? If this is the case then you need to follow this checklist- 1. Start SQL Server in some user account rather than system account. 2. Share the folder containing excel sheets and give read permissions to the user account(used to start SQL Server) on this folder. I think this should solve your problem. Gaurav