"Object required" - path string unrecognized in windows scripting file

• Set in VBScript is only for "object-types" (COM Objects, etc), but String values are not "objects" (as far as VBScript is concerned), so don't use Set.

  • You can either remove the Set keyword but otherwise keep the assignment statement as-is, or altenatively use the Let keyword instead of Set: Let is for non-object values (including Strings, but also Integers and Doubles).

• In VBScript, when calling a Function (or COM Method) that returns a value you need to specify parentheses, you only omit the parentheses when calling a Sub (i.e. a void function or method) (unless you're using the Call statement), in this case TextStream.ReadAll() returns a String value.

• Use the named-constant ForReading instead of the magic-number literal 1.

• You also should add Option Explicit at the first-line of your script, otherwise VBScript won't care about variable declarations (indeed: objOutFile is declared, but objInFile is what's actually used....)

<job id="Test_Script">
   <script language="VBScript">

    Option Explicit

    Dim objFSO, strSourcePath, strSourceFile, objInFile, strData    

    Let strSourcePath = "C:\test\ERACSV\"
    Let strSourceFile = "Payments.csv"
    Set objFSO        = CreateObject("Scripting.FileSystemObject")   
    Set objInFile     = objFSO.OpenTextFile(strSourcePath & strSourceFile, ForReading, False)
    Let strData       = objInFile.ReadAll()
    objInFile.Close

    WScript.Echo strData
   </script>
</job>