Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PaulTeal
Yak Posting Veteran
67 Posts |
 Posted - 2003-07-25 : 23:28:42
|
| My DTS package editor is always freezing up on me. It will lock up if I hit the data driven query task or if I right click on certain data pumps an select 'properties'.I've already reinstalled my client tools, are any of you experiencing this? Any ideas how I can minimize this, since I am at a standstill?Paul Tealpaul@partytilyoupop.com |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-28 : 11:43:02
|
| You don't mention how many transformations you've got...and I'll bet your transforming an access database with a lot of objects...Everytime you open that up, DTS has to read all of the collections to figure out what's going on..If there a ton of objects...it'll look like it's frozen...it's just taking a long time to revalute everythingMak a copy of the access database and only use the objects you need.That is if that's what you're doing...That has been one of my experiences...Brett8-) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-28 : 12:57:34
|
| You should install service pack 3a on your client machine. Service packs are not only for the servers but they are also for the clients. But the recommendation is that both the client and the server should be on the same service pack. A lot of people experience problems with DTS when not on the same service pack.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-28 : 13:19:44
|
| Thanks Tara,Never knew that...Fortunatley, it's not really a problem...I tend to stay away from DTS...But still good to know...what else does it fix?Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-28 : 13:22:30
|
quote:
Originally posted by X002548
Fortunatley, it's not really a problem...I tend to stay away from DTS...But still good to know...what else does it fix?
I try to stay away from it as well. Not sure what the service packs do on a client machine, but you'll find some quirky things happening in DTS if you are on a different service pack level than the server. This was definitely true in 7.0. I haven't seen it happen in 2000 yet, but it's still a good idea to be on the same service pack as the server.Tara |
|
|
|
|
|
|
DTS Freeze