December 12, 2007 at 7:09 am
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!
December 12, 2007 at 7:53 am
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
December 12, 2007 at 8:30 am
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