Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Unanswered: ActiveXScripting Error

    Has anyone come across this.
    I haven't found anything online as of yet.
    I'm using VBScript to copy a file from one server to another.
    This scripts works on all other servers but for some reason I get this error.
    Anyone have any suggestions or work arounds.

    I'm doing a nightly backup of a database which I copy from one server to the other as a scheduled job.

    ActiveScripting specific error 257

    thanks,
    Jonathan

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by jdmarsh2g
    Has anyone come across this.
    I haven't found anything online as of yet.
    I'm using VBScript to copy a file from one server to another.
    This scripts works on all other servers but for some reason I get this error.
    Anyone have any suggestions or work arounds.

    I'm doing a nightly backup of a database which I copy from one server to the other as a scheduled job.

    ActiveScripting specific error 257

    thanks,
    Jonathan
    Security issue for the destination ? Check the account running the SQLAgent.

  3. #3
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123
    Thank you I appreicate it
    yeah I thought of that...
    both agent accounts are part of our domain group...
    these servers just seem to be the only ones with this issue....

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Sometimes, seing the code helps in debugging

    And heck, even a line number can save hours of guess work too
    George
    Home | Blog

  5. #5
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Here you go

    '************************************************* *********************
    ' Visual Basic ActiveX Script Copy Source files
    '************************************************* ***********************



    ' Copy File
    Option Explicit

    Function Main()

    Dim oFSO
    Dim sSourceFile
    Dim sDestinationFile

    Set oFSO = CreateObject("Scripting.FileSystemObject")

    sSourceFile = "G:\MSSQL\BackupRepl\arsystem\arsystem_backup_devi ce.bak"
    sDestinationFile = "\\svr-wrc-itsmdb\g$\MSSQL\BackupRepl\arsystem\arsystem_backu p_device.bak"



    oFSO.CopyFile sSourceFile, sDestinationFile

    ' Clean Up
    Set oFSO = Nothing

    'Main = DTSTaskExecResult_Success
    End Function

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Did you copy and paste the exact code?
    Code:
    arsystem_backup_devi ce.bak"
    Also, is there definately a G drive?
    George
    Home | Blog

  7. #7
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by georgev
    Did you copy and paste the exact code?
    Code:
    arsystem_backup_devi ce.bak"
    Also, is there definately a G drive?
    also:
    arsystem_backu p_device.bak"

    With DTS when you run the DTS job from your client, it uses your permissions and mappings, when you run it via an agent job, it uses the server permissions and drive mappings, so you should verify this on the server from which the agent job is running, assuming it is running via an agent job.

  8. #8
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123
    the pasting did that..... yes there is a G:\ drive

  9. #9
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by jdmarsh2g
    the pasting did that..... yes there is a G:\ drive
    You need to uncomment 'Main = DTSTaskExecResult_Success

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •