Post reply

Coping files from server to another machine

  • August 8, 2008 at 4:24 am

    #190743

    Hi I have generated excel files using sql server stored procedures.

    Now I need to copy those files to other machine in the network from sql server machine (where server is running)

    Is this possible?

    If yes, please tell me solution or any ways to do it.

    thanks

    jayasri

  • August 8, 2008 at 5:39 am

    #855042

    One solution is to use xp_cmdshell to copy the files to a network share (note that you need to enable xp_cmdshell, and your SQL Server service account must have permission to the share)

    For more information see http://msdn.microsoft.com/en-us/library/ms175046.aspx

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply