Archive for January, 2012
NEWS: Apple overtakes Hewlett-Packard to become No 1 PC maker: Canalys
Title says everything …. you can check more here: http://economictimes.indiatimes.com/tech/hardware/apple-overtakes-hewlett-packard-to-become-no-1-pc-maker-canalys/articleshow/11696305.cms Thanks, Khilit
January 31, 2012
· 
Khilitchandra Prajapati · 
No Comments
Posted in: General
SQL Server 2012 Virtual Launch Event & Sweepstakes too :)
Microsoft is going to host the SQL Server 2012 Virtual Launch Event (VLE) On March 7, 2012, in order to share the latest on SQL Server 2012 and the evolution of the Microsoft data platform. Check out the SQL Server Team Blog for more details: http://blogs.technet.com/b/dataplatforminsider/archive/2012/01/26/join-us-march-7-2012-for-the-virtual-launch-of-sql-server-2012.aspx To participate in VLE, you can register here: http://www.sqlserverlaunch.com/ww/Register [...]
January 30, 2012
· Khilitchandra Prajapati · No Comments
Tags: SQL 2012 · Posted in: Microsoft Event, SQL Server
SQL Server 2012 RC0 – Quick Start
Guys, I know we can simply Google this information. But believe me these links are quite enough to your quick start needs for SQL Server 2012 RC0 Where can I download it from? http://www.microsoft.com/download/en/details.aspx?id=28145
January 27, 2012
· Khilitchandra Prajapati · One Comment
Posted in: Business Intelligence, New Features, SQL Server, Tutorial
I have “System.Reflection.TargetInvocationException” in my SSIS Package!!!
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 [...]
January 27, 2012
· Khilitchandra Prajapati · 2 Comments
Posted in: Quick Tips, SQL Server, SSIS
When my SQL table was updated???
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 * [...]
January 27, 2012
· Khilitchandra Prajapati · One Comment
Tags: sql database, sql query · Posted in: General, Interview QA, Quick Tips, SQL Server, Suggestion, T-SQL
Look-up Task fails in SSIS2005
You already know that SSIS 2005 has more issues than SSIS 2008 version. I have also came across an issue regarding Look-up Task. When you use Look-up Task in your dataflow activity. Sometime it runs and sometimes it fails. Well, there could be many reasons, but we will discuss about one of the reason that [...]
January 27, 2012
· Khilitchandra Prajapati · No Comments
Posted in: SQL Server, SSIS
How Do I Configure My SSIS Package?
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 [...]
January 27, 2012
· Khilitchandra Prajapati · 3 Comments
Posted in: Quick Tips, SSIS, Tutorial
Passing values from one package to another package
In this demo, I will show you how we can transfer values from one package to another package. I will create one SSIS project. And add 2 packages in it. ParentPackage and ChildPackage as shown below.
January 27, 2012
· Khilitchandra Prajapati · No Comments
Posted in: Interview QA, Quick Tips, SSIS, Suggestion
Select records from one table which are not available in another table
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 [...]
January 27, 2012
· Khilitchandra Prajapati · No Comments
Posted in: General, SQL Server, Suggestion
