Wednesday, September 26, 2007

A less than directionful error message

Error Message: The table "[dbo].[SSISConfiguration]" cannot be used as a source for SQL Server configurations. This table does not have the necessary columns needed for storing configuration information.

Resolution: This error message may lead you to believe that the table you've created is somehow incorrect in its format. It is much more likely it's because you're pointing at the wrong database. It would be nice if the error message lead you to believe that the object didn't exist, rather than that it was somehow malformed.

Purpose

The purpose of this blog is simple. As I experience problems during the development of the data warehouse I'm working on, I'll make posts here. This is in hopes that someone else may have their problems solved without having to puzzle them out themselves.