Post reply

SQL Server Jobs Executing DTS Packages

  • August 13, 2002 at 9:22 am

    #105671

    [font=Tahoma]]

    Ok, here's my problem. I've set up a DTS package that opens FoxPro Tables and reads the data into SQL Server on a nightly basis. There are no problems setting up the package, no problems executing the package from the command line with DTSRUN, no problems executing the package within the DTS Designer.

    Yet, I've set up a SQL Server Agent Job that runs a nightly execution of DTSRUN (exact syntax that I use manually from the command line) and it fails to find the FoxPro tables.

    What can I be missing. I can run the package from the local server and from a remote workstation through the command line. But the Native Job fails.

    Here is a sample of the code I am utilizing

    DTSRUN /S10.10.*.* /Usa /P[edited] /NUpdateClasses /M

    this syntax works from the command line but not SQL server. Can anybody help?

    [/font=Tahoma

    -------------------------

    "Computer games don't affect kids; I mean if Pac-Man affected us as kids,

    we'd all be running around in darkened rooms, munching magic pills and

    listening to repetitive electronic music."


    -------------------------
    "Computer games don't affect kids; I mean if Pac-Man affected us as kids,
    we'd all be running around in darkened rooms, munching magic pills and
    listening to repetitive electronic music."

  • August 13, 2002 at 10:11 pm

    #434539

    Don't you hate when security issues get in the way of getting the job done?

    SA doesn't have the necessary permissions to the fox files directory. Use a trusted connection, and have the job run under the context of a user that has permissions to the directory.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply