Welcome to EMC Consulting Blogs Sign in | Join | Help

SSIS Junkie

SSIS: Error message reference on its way!

Good news. BOL is going to include a list of all the errors that SSIS can produce and it should be with us by RTM in November. That should be a great help in debugging your packages I reckon. Read more here: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=106107 Thanks to Doug Laudenshlager for the info!



An answer from Doug to Frans van Bree's comment (below):

"It's my understanding that errors, warnings, and informational messages from Microsoft-provided Integration Services components are all included in the HResults class already documented (though without the hex codes) in the API reference, as mentioned in my previous post.

These will also be included, with hexadecimal codes, in the new topic that I mentioned."

Published Monday, October 10, 2005 8:59 PM by jamie.thomson



Frans van Bree said:


Is there also a list of eventcodes? The OnInformation event can return a multitude of possible event codes and accompanying event descriptions.

Or are the event codes internally stored in an the error code table?

(For the OnInformation event the ErrorCode property is used to store the EventCode...)
October 11, 2005 9:28 AM

jamie.thomson said:

Very good question indeed. And I don't know the answer to it. I'll find out!

October 11, 2005 12:05 PM

Arvind Ranganath said:


On this - Or are the event codes internally stored in an the error code table?

I reckon it will be very handy to have this in error table. Do we have any answers or should I go and do a painful task of copying all error msg/nos to a database table in SQL Server?

Pls let me know.


January 8, 2007 8:00 PM
New Comments to this post are disabled

This Blog


Powered by Community Server (Personal Edition), by Telligent Systems