December 30, 2003 at 11:33 am
Hey all,
Strange DTS trouble.
Our DEV box is SQL 7.0, BETA and PROD are 2000 and we use lots of DTS.
One of the packages in DEV(7.0) was edited from a 2000 box. Now the package will not run to completion but does not throw any errors.
It the past deleting and re-creating every object inside the package fixed it. Sometimes rolling back a version would work too. Now nothing fixes it.
Have you had this kind of DTS package corruption in 7.0?
Were you able to fix it?
Many thanks!
Skål - jh
Edited by - omhoge on 12/30/2003 11:34:40 AM
Skål - jh
December 31, 2003 at 6:38 am
mdac-components are stored in the dts-package, that is the problem !
ALWAYS (shout is out as loud as you can) edit packages on the server itself ! Not from a client! (unless you are sure it is at exact the same level as the DTS server)
Don't know for sure, but it might be SQL7 sp4 handles this issue.
Best wishes
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 31, 2003 at 9:13 am
Thanks alzdba,
Yes, agreed editing should always be done on the server. In multi server enviroments it can happen all too easily though.
I'll probably just have to re-build, I'm sure the dev team has learned the lesson.
Skål - jh
Skål - jh
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply