So on 6/30 a new SQL MP was released. It has some great new features and fixes:
http://www.microsoft.com/en-us/download/details.aspx?id=10631
and some awesome new instance level dashboards for both SQL 2008 and 2012 when used with SCOM 2012+
Unfortunately, the MP also doesn’t play nice with SCOM 2007 R2 and its predecessor 6.4.1 MP. When you try to import it into your 2007 R2 environment with the previous version of the SQL MP installed you will get failures of all the 2012 MP components
This error is not particularly helpful but if you go to the OpsMgr Event log it helps narrow things down:
So the workaround is to remove the SQL 2012 6.4.1 MPs and then reimport 6.5.1:
This should fix the issue, but ultimately you should really upgrade to 2012 R2 as 2007 R2 fell out of mainstream support on 7/8/2014 so any new MP’s going forward will likely be the 2.0 schema and completely incompatible.