dbTalk Databases Forums  

Error message in DTS

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Error message in DTS in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Greenberg
 
Posts: n/a

Default Error message in DTS - 10-29-2007 , 05:24 AM






Hi
In my DTS I am updating an Ingres database on a different server.
I'm getting the following error immedtiately ....

HResult of 0x80040e09 (-2147217911) returned
Unexpected error occured. An error was returned without an error message

Anyone know what its about ?

Thanks !!


Reply With Quote
  #2  
Old   
David Greenberg
 
Posts: n/a

Default Re: Error message in DTS - 10-31-2007 , 01:36 AM






Ok guys, I worked this one out and thought maybe some of you would be
interested in hearing it (even though no one responded to the initial
posting).
I searched the net a bit and saw that other ppl get the same message
when performing actions on databases (of any kind) on other servers.
The message I put in the posting was what I got when I ran the DTS step
by step when I was writing and checking it.
The error message I got when running it as a package was an ODBC message
giving me the actual Ingres error.
Hence the error message ...
"Unexpected error occured. An error was returned without an error message"
There is no error message within SqlServer because the error message is
external from Ingres.


David Greenberg wrote:
Quote:
Hi
In my DTS I am updating an Ingres database on a different server.
I'm getting the following error immedtiately ....

HResult of 0x80040e09 (-2147217911) returned
Unexpected error occured. An error was returned without an error message

Anyone know what its about ?

Thanks !!



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.