Post reply

skipping datapump

  • July 3, 2003 at 10:57 am

    #160271

    Good morning all,

    I have an old reliable DTS package that consists of 20 datapumps run sequentialy. Each datapump moves table data from an ODBC database into a local SQL 7 table. Each pump is set to quit on failure and continue on success. It's been running each night for about two years.

    I noticed that for the last two nights pump 5 has been skipped, no error, nothing special in the log, just skipped. I haven't changed anything I am aware of and I can't see any problem in the pump configuration.

    Any ideas why this is happening?

    Thank you!

  • July 3, 2003 at 12:49 pm

    #464129

    I just realized, the pump seems to have run, there is updated data in the destination table. Just no entry in the job log. So it seems to be a problem with logging.

    Any thoughts?

    Jonathan

  • July 3, 2003 at 7:05 pm

    #464149

    Well if you haven't made any changes to the package. You'd best check what else has changed in terms or security, structure, server and database settings.

    What is the ODBC source? Has anything changed on that end?

    Hope this helps

    Phill Carter

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

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

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

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