Server Info from SSIS

We can use WMI(Windows Management Instrumentation) to find Server Information from SSIS rather than using SQL. See below link
http://www.mssqltips.com/sqlservertip/2932/using-the-ssis-wmi-task-to-gather-system-information/

Comparing T-SQL and MDX

http://www.mssqltips.com/sqlservertip/2916/comparison-of-queries-written-in-tsql-and-sql-server-mdx/

This Link may be helpful to some extent to understand MDX

Eecution Plan in SQL Server

http://stackoverflow.com/questions/7359702/how-do-i-obtain-a-query-execution-plan