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 |
|
philackerley
Starting Member
2 Posts |
 Posted - 2004-06-24 : 04:21:32
|
I have the following message if I try to open any transform data object property window in a specific DTS package on my Server. It is a production DTS and I need to know how it works and modify it due to database changes.---------------------------Package Error---------------------------HResult of 0x80004005 (-2147467259) returnedUnexpected error occurred. An error result was returned without an error message.Has anyone seen this and able to remedy it? Or anyone has tried a successful way of exporting-reimporting the DTS to fix it? I have tried but the error comes along with it!I am running Microsoft SQL Enterprise Manager Version: 8.0 on my Windows XP machine...connecting to a SQL SERVER 8.00.760 Enterprise Edition.Appreciated  |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-24 : 04:27:55
|
| Yeah, either your client machine you are trying to view this on has a different service pack level to the server or youy have an old version of mdac... |
 |
|
|
philackerley
Starting Member
2 Posts |
Posted - 2004-06-24 : 07:24:07
|
| Thanks....I have actually ventured over to Windows from the LinuxªORACLE world..so bear with me..SO I need to get the correct SP on the SQL Server 2000 to match with my WIn XP machine ( SP1 I think) and also there is a MDAC situation..I have downloaded and applied MDAC 2.8 and this seemed okay...but I still cannot work on the DTS...Is there an order to doing this?What neds to match...do Microsoft maintain a x-reference showing what is needed?thanks! |
|
|
|
|
|
|
DTS Unexpected Error ..Corrupted?