Hi guys,
I've built a small class to take in a filename (.csv), launch SQL*Loader & push it into a specific table. This class works fine in my windows app but when I try to run it from a web service I get the following error with the control file:
SQL*Loader-500: Unable to open file (control.ctl)
SQL*Loader-554: error opening file
SQL*Loader-509: System error: The device does not recognize the command.
(bear in mind the details being used for the web service & windows app ARE THE EXACT SAME).
Code to launch the process is as follows:
Dim psi As System.Diagnostics.Process = New System.Diagnostics.Process
psi.StartInfo.FileName = SQLLoader
psi.StartInfo.UseShellExecute = False
psi.StartInfo.RedirectStandardOutput = True
psi.StartInfo.RedirectStandardError = True
psi.StartInfo.Arguments = file
psi.Start()
psi.WaitForExit()
Any help at all would be appreciated, as this is quite urgent.
I've built a small class to take in a filename (.csv), launch SQL*Loader & push it into a specific table. This class works fine in my windows app but when I try to run it from a web service I get the following error with the control file:
SQL*Loader-500: Unable to open file (control.ctl)
SQL*Loader-554: error opening file
SQL*Loader-509: System error: The device does not recognize the command.
(bear in mind the details being used for the web service & windows app ARE THE EXACT SAME).
Code to launch the process is as follows:
Dim psi As System.Diagnostics.Process = New System.Diagnostics.Process
psi.StartInfo.FileName = SQLLoader
psi.StartInfo.UseShellExecute = False
psi.StartInfo.RedirectStandardOutput = True
psi.StartInfo.RedirectStandardError = True
psi.StartInfo.Arguments = file
psi.Start()
psi.WaitForExit()
Any help at all would be appreciated, as this is quite urgent.