Category Archives: Quick Tips

Browse an SSAS Cube using Excel – Automatic Setup done by SQL Server Data Tools

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, Most of us; who are working on SQL BI solutions are aware of connecting SSAS Cube using Excel (as client) for browsing. Because we know that how much the clients/financial users likes to work with Excel 🙂 In SQL 2012 RC0, there is one handy-dandy quick-link which enables us to make this whole functionality ready-made in few seconds. Believe it or not, try the following: Open “SQL Server Data Tools” (This is new name assigned to Visual Studio IDE/BIDS in SQL Server 2012 RC0) Use MultiDimensionalProject & create a cube with any method you want. Process & Deploy … Continue reading →

Demo Site is ready with full featured “SQL Server 2012 RC0” to play with

Khilitchandra's Business Intelligence Blog Posted on by

Note: This site requires Windows 7, Windows Vista with SP1/SP2 or Windows XP wth SP3 to have the correct RDP client to use this site. Go to this site http://fs.mssalesdemos.com/, Login with your live ID. Select the “Catalog” tab. Select “New SQL Server 2012-RC0 fully integrated Demo“. The new SQL Server 2012-RC0 demo is fully integrated with SQL Server 2012, SharePoint 2010 and Office 2010 including: • PowerPivot and MDS Excel integration • Reporting Services integration with SharePoint • Power View integrated with SharePoint • Data Quality Services

Continue reading →

I have “System.Reflection.TargetInvocationException” in my SSIS Package!!!

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, I have got the following error message in my SSIS logs on executing one of my SSIS packages. Error Message: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.InvalidOperationException: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application. at System.Windows.Forms.MessageBox.ShowCore(IWin32Window owner, String text, String caption, MessageBoxButtons buttons, MessageBoxIcon icon, MessageBoxDefaultButton defaultButton, MessageBoxOptions options, Boolean showHelp) at System.Windows.Forms.MessageBox.Show(String text) at ST_c90e6b7b7027452898f11e3ccc01c81a.csproj.ScriptMain.Main() — End of inner exception stack trace — … Continue reading →

When my SQL table was updated???

Khilitchandra's Business Intelligence Blog Posted on by

Here is very tiny SQL query which will help you find out when the tables are modified in the SQL server database. First you try the * (get all the columns) and then choose the selected ones. — List all the tables updated in SQL Server (in desc order) Use your Database Name Select * from sys.tables order by Modify_date desc Like wise, you can also check few more readymade tables which store some helpful information for you.

Continue reading →

How Do I Configure My SSIS Package?

Khilitchandra's Business Intelligence Blog Posted on by

Well, the correct answer to this question is – “That Depends“. There are lots of things requires your attention when you start making your package configurable. For better illustration, lets take e.g. of one simple scenario. I have a package named “TransferDataPackage.dtsx“. This has only one data flow task in which, i have a OLEBD Source and OLEDB Destination tasks. In short, i am transfering data from “SourceServer” to “DestinationServer”. (Names in double quotes are exact names of entities used in example) And now i want to make this package configurable. Demo project is shown below:

Continue reading →