Home Forums SQL Server 2005 T-SQL (SS2K5) Running xcopy commend from Select Statement RE: Running xcopy commend from Select Statement

  • May 16, 2013 at 1:13 pm

    #1615974

    skb 44459 (5/16/2013)

    select

    OrderNum,

    OrderLine,

    OrderRelease

    FileTemplateName

    from OrderLines

    I would like to run a xcopy statement for each record and copy the file from FileTemplateName to

    c:\OrderFiles\<OrderNUm>\<OrderLine>\<OrderRelease>\<OrderNum>_<OrderLine>_<OrderRelease>_FileTemplateName

    I am guessing that what you have is just the file name stored in the database and you want to make a physical copy of the existing file in the new location? Are these files in the directory on the sql server or another server? If they are on the same server I would think you could do this with CLR fairly easily. If they are on another server this could get pretty tricky.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/