SQL Server Performance

DTS From One Server To Another

Discussion in 'SQL Server DTS-Related Questions' started by Macker, Jun 17, 2003.

  1. Macker New Member

    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?
  2. gaurav_bindlish New Member

    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.

  3. Macker New Member

    Thanks for the quick reply. I was told to use UNC to transfer the Files?
  4. gaurav_bindlish New Member

    Pardon me for my ignorance. What do you mean by UNC?

  5. satya Moderator

    Universal Naming Convention, which you use as \servernamepathfilename.

    Satya SKJ
  6. gaurav_bindlish New Member

    Thanks Satya!

    Macker, transfer of file is not required for your operation.


Share This Page