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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS Package Error

Author  Topic 

1fred
Posting Yak Master

158 Posts

Posted - 2004-03-05 : 16:08:10
Hresult of 0x80004005 (-2147467259)returned
unexpected error occured. An error result was returned without an error message.

I have the following message whenever I try to double click on a transform data task in any of my DTS package. Because of this error I can't edit my task, the window is not showing. Pretty weird, anyone got an idea?

ChrisFretwell
Starting Member

43 Posts

Posted - 2004-03-05 : 16:34:11
What version of sql? Which service pack? What service pack on the client machine if you are not creating on teh server itself?

Chris
Go to Top of Page

1fred
Posting Yak Master

158 Posts

Posted - 2004-03-05 : 16:38:12
I have SQL SP2 both on the client and Server. The error first appeared on the client and then I tried to see if it was the same on the server and it is.
Go to Top of Page

1fred
Posting Yak Master

158 Posts

Posted - 2004-03-05 : 17:10:12
WOW! I found the problem... I was working on the server machine to try to find anything, I even restarted it. Then I came back to my desktop, after a while, I juste closed my Enterprise Manager and open it again. It is working now!!! Really weird!
Go to Top of Page

kiwisungni3
Starting Member

1 Post

Posted - 2008-11-11 : 15:23:54
I know this posting is old, but I'm getting the same error. I am able to open the tranformation task to edit the query, but when I try to close the window w/ the changes, I get this error.

I've re-started my enterprise mngr serveral times and still no luck...

Any help?
Go to Top of Page
   

- Advertisement -