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?
    Thanks
    Macker, Jun 17, 2003
    #2

  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.

    Gaurav
    gaurav_bindlish, Jun 17, 2003
    #2

  3. Macker New Member

    Thanks for the quick reply. I was told to use UNC to transfer the Files?
    Macker, Jun 17, 2003
    #2

  4. gaurav_bindlish New Member

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

    Gaurav
    gaurav_bindlish, Jun 17, 2003
    #2

  5. satya Moderator

    Universal Naming Convention, which you use as \servernamepathfilename.

    _________
    Satya SKJ
    satya, Jun 18, 2003
    #2

  6. gaurav_bindlish New Member

    Thanks Satya!

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

    Gaurav
    gaurav_bindlish, Jun 18, 2003
    #2

Share This Page