Hi, morning

yesterday i faced one problem as this:

when i open DTS on my pc, it take quite no of time to open it even just a short DTS, before that just open whatever i need to open take about few second. when i go to restart my SQL server, it become as usual on my pc. it happened several time yesterday, any way to resolve the problem or what is a problem to couse it happend?


thanks


Jane

You may have a lot of modification to that package and every time you make a change it logs the history(revisions) of changes, so when you open it the dts package it also load the history.

In Enterprise Manager, right click your dts package and select revisions, there you will see the all revisions you have made. delete the ones you don't need.


Jaime E. Maccou
Applications Analyst