.Net exe application set as SQL job in SQL Server 2000 doesn' run correctly RRS feed

  • Question

  • hi guys!


    i have a exe db application that parses a .DAT file from a remote server directory to my local SQL server table. 

    my problem is that if i set the .net exe application as a job in MS SQL server and run it, it doesn't parse the file into the SQL table.  if i run the .exe application by simply double clicking it from the windows explorer bar, it does parse the .DAT file into my SQL table.

    is there any rights or permission conflicts running the .exe as a job in SQL server since it accesses the file from another remote server directory?  HINT: my local server is not a member of the domain of the remote server that contains the .DAT file directory, however, i am able to map its drive directory into my local server.


    thanks in advance!



    Friday, June 8, 2007 12:37 PM

All replies