I'm going through the MS SQL Server SSIS Step by Step book from Microsoft Press and I think I have an issue with my install of MS SQL Server.ÃÂ On the first exercise, the book instructs you to open an existing project and then open a data source view from the project.ÃÂ The data source view contains several table objects and a named query object.ÃÂ When I right-click on the named query object and then choose 'Edit Named Query .', I get a pair of 'Object reference not set to an instance of an object' errors.ÃÂ This also happens if I double-click on the object itself.
I created a blank project. ÃÂ Then I created a Data Source View and populated it with tables from an existingÃÂ database using the wizard.ÃÂ When I tried to add a new named query I got the same error.
Is there a configuration error here?ÃÂ So far all of the other functions have worked normally.
SQL Server 2005 Developer - SP2 (all patches applied) (SQL Server 2005 Evaluation exhibits the same error)
View Complete Post