Post reply

Shedule package to copy data from paradox to SQL

  • June 30, 2006 at 6:25 am

    #68725

    I have written a package to copy data from j:\winjan\history\history.db to a db in sql

    The package works fine if I execute it from enterprise manager. It deletes existing data and copies the new stuff in.

    When I shedule the job it always fails and complains it cannot access the paradox.net file.

    Any clues?

  • June 30, 2006 at 12:01 pm

    #647047

    does the sql agent service identity have rights to that folder and file?  When you execute a package interactively it uses your account, when scheduled as  job it will use the sql agent identity.

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

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