SQL Server Performance

Copy a flat file to another Windows Server

Discussion in 'General Developer Questions' started by hjyoungii, Oct 16, 2006.

  1. hjyoungii New Member

    I have a file created as tab delimited that I need to copy to another non SQL server.

    Any suggestions on how to do this.

    Both servers have Windows 2003 on them. The source is running MS SQL 2000 where the file is created.

    The destination only needs to have the file copied to it. There is no need to import it into a database.
    hjyoungii, Oct 16, 2006
    #2

  2. Bredsox New Member

    quote:Originally posted by hjyoungii

    I have a file created as tab delimited that I need to copy to another non SQL server.

    Any suggestions on how to do this.

    Both servers have Windows 2003 on them. The source is running MS SQL 2000 where the file is created.

    The destination only needs to have the file copied to it. There is no need to import it into a database.


    Check this out:
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6999
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8478
    Bredsox, Oct 16, 2006
    #2

  3. mmarovic Active Member

    You can also use DTS.
    mmarovic, Oct 16, 2006
    #2

  4. satya Moderator

    You can use XP_ CMDSHELL in this case to copy the file between the servers and make sure the SQLAgent account has required privileges to process the task.

    But why don't you perform the filecopy operation using the Scheduler service on Windows 2003.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Oct 16, 2006
    #2

  5. hjyoungii New Member

    I would like to thank all of you for your help. I have now successfully got the file copied over to where it is needed and able to have a job ready to run when needed.
    hjyoungii, Oct 16, 2006
    #2

Share This Page