DTS 2000 Package hangs while saving.

  • Saving a package hangs within designer for an extremly long time. Sometimes up to half hour! I can make a new copy and make changes, saving along the way without a problem, But NOT once the package is run.

    Package -

    creates & populate temp table

    Deletes & populates target db table.

    Run Query

    ActiveX to write formatted text file (85meg) from query

    Delete & Import flat file to import table.

    Run three Updates based on import file to target db table.

    I opened it , made minor adjustment to a few of the steps, saving along the way, no problem Exectued the package, no problem. Saving the package, started 20 minutes ago and hour-glass is still turnin!

  • A problem with your workstation?

    Use the profiler and sp_who2 to see what is going on at the server where the package is being saved.

    Norman

    DTS Packaeg Search

    http://www.dtspackagesearch.com/

  • I'll try that with a little assist from our dba to make sure to target any suspect process. I'm afraid that running on a dev box, not much activity we won't find much.

    I'm curious about 'objects' within the package. Such as the temp tables or file system object that writes the 85meg file. Can clean-up be an issue? I tried closing and setting fso but recieved 'method' errors.

    I'm trying to figure out why opening and saving is not an issue until after execution.

    Randy.

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

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