How do you synchronise Reporting1 and Reporting2? If Reporting1 is toggled as the 'loading' DB, and therefore Reporting2 is the 'live' DB, then at some point (after the load is...
This article at http://www.sqldts.com/?234 (great site, BTW) mentions that the syntax validation routine for the design-time parser is less forgiving that...