Just drag an Execute SQL Task and double click to open SQL Task Editor. Under the SQL Statement section, you will find the slot for Connection.
Click on New connection and you will see the Configure OleDb connection Manager window. Click on the New button.
Now , you will find the window called Connection Manager. Click the provider called Native OleDb/SQL Server Native Client and choose Microsoft OLEDB provider for Analysis Services 10.0.
Now, click ok and go back to the SQL Task Editor window and write your MDX statement (I used a Create Global Cube statement for creating a local cube). Now, you can exeucte the task and see the result.