Post reply

DTS

  • January 8, 2007 at 2:49 am

    #67903

    hi all,

     

    do you have any idea how to execute this line in activx script.

    "exec master..xp_cmdshell copy"

  • January 8, 2007 at 6:33 am

    #681743

    What are you trying to do?  If you are trying to copy a file in ActiveX script, you would be better off using the file system object.  See http://www.sqldts.com/292.aspx. 

    If you need to run the exact statement, you can run it from an Execute SQL task (beware that security settings may prevent this from working).

    Russel Loski, MCSE Business Intelligence, Data Platform

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

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