Change the output path so you are using two MDF files.

I have used following Query

SELECT NON EMPTY { [Measures].[InventoryQty] } ON COLUMNS, NON EMPTY { ([Branch].[Branch Code].[Branch Code].ALLMEMBERS * [Currency].[Currency].[Currency].ALLMEMBERS * [Branch].[Branch Name].[Branch Name].ALLMEMBERS ) }

DIMENSION PROPERTIES...

Cracked it!

EXEC('CALL usp_test') AT MYSQLLOCALHOST

EXEC MYSQLLOCALHOST.rhys.root.usp_test

/*------------------------

EXEC MYSQLLOCALHOST.rhys.root.usp_test

------------------------*/

OLE DB provider "MSDASQL" for linked server "MYSQLLOCALHOST" returned message "[MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL...

thanks

Thanks Jason!

That's just what I needed too!

sweetie,

1. If the package fails, you can find out more about the error if you double click the failed step when it pops up the failed dialog. Yes, I didn't...

Hi and thank you for an excellent article!

Do you know if it's possible to let the user enter some data in the report, like a textfield or textarea?

/Jonas

Awesome, thanks for your help!