RSS

Monthly Archives: 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

 

 
1 Comment

Posted by on January 31, 2012 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

Find more details of this event here: http://www.sqlserverlaunch.com/ww/Home

Find out the full list of agenda on this event: http://www.sqlserverlaunch.com/ww/agenda

Breakthrough Insights:

Read the rest of this entry »

 
 

Tags:

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

Read the rest of this entry »

 

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 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 — at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()

Read the rest of this entry »

 
2 Comments

Posted by on January 27, 2012 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 * 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.

Read the rest of this entry »

 

Tags: ,

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 is related to the “caching”. Look-up uses caching for fast comparision of values.

So, you might have faced something like this. You have configured look-up correctly and when you run, you will see following :(

Read the rest of this entry »

 
Leave a comment

Posted by on January 27, 2012 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 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:

Read the rest of this entry »

 
3 Comments

Posted by on January 27, 2012 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.

Read the rest of this entry »

 

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 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 Task is to provide the matching key. And we want those keys (Records) which are not matching. Simple answer to this is – Lookup Task.

Read the rest of this entry »