Category Archives: Interview QA

Data Mining for Social Moderation – Event @ Microsoft, Singapore on 6th Feb 2012

Khilitchandra's Business Intelligence Blog Posted on by

The BBC (the British Broadcasting Company), a known media force in Europe, implemented an in-database data mining solution for their public-facing website. The BBC encourages users to post comments and become part of their social media community. In this project, the BBC needed a way to improve the social moderation of millions of posts on thousands of forums. This presentation covers how SQL Server helped designing a model to dramatically help improving the quality and efficiency of the moderation. We also discuss cost efficiencies obtained in this project. More and more organizations will need to use enterprise solutions to handle … 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 →

Select records from one table which are not available in another table

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys. I have seen people having hard time when they try to achieve similar functionality which is provided by “Except” keyword in T-SQL. I am talking about the case when people need to select those records from one table which are not available in another table. Well, if both these tables are in one database, you can definately use SQL query and make use of Except keywork. But if tables are in different database then… And then people start experimenting with Merge Join Task and later start googling it. One of the mandatory condition while using the Merge Join … Continue reading →