I actually found a way to get this to work. Of course you should need to have Oracle client on the server running the package, but instead of using...

I don't know if this will help, but here's what I did:

'Count Records in Datafile

Set FSO = CreateObject("Scripting.FileSystemObject")

Set lfInputFile = FSO.GetFile(vPath&"\yourfilename")

Set ltsInput =...