T.H.E.M - Tottaly Hidden Extreme Magic

I am fan of Cyril long after watching his videos on YouTube. They were Japanese made, however you were able to understand and impress by Cyril magic tricks and wonders.

Recently I saw some episodes of Cyril: Simply Magic which are been broadcasted on AXN.

After checking on YouTube and found out that Cyril were part of other magic shows too. One of them is T.H.E.M. After watching I am impressed. I thought better share it on my blog too.

Error 0xc0204016: DTS.Pipeline - SQL Server

It was just another week back. I've been asked to transfer data from SQL server to MS Access and Excel. It is been little longer time that I have used SQL Server. So I thought it as a challenge! I know there were tools to do the needful. However, the best tool was Data Transformation Services (DTS) which came with SQL Server 2000 in the old days. Now it is more improved and it bundles with SQL Server 2005 and the tool named SQL Server Integrated Services (SSIS).

Now for SQL Server 2005 Express edition you have to download this and install it separately.

Download the Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB)

And later you can run it

Run "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"

I thought work is going to be easy until I found the error messages I have received. I searched through the Net to find the solution. There were, however they were not simple as I thought.

Some were explaining to change the destination source file, such as to change the table column to memo. It is little confusing, since the tables are yet to be created.

I tried few SQL scripts too and nothing went well.

The reason this error message prompted was that one of the column field size is more than accepted at the destination file (in my case it is MS Access).

After reading this article (http://blogs.msdn.com/b/sqlazure/archive/2010/06/01/10018602.aspx) only I have realised that I did not try to change the source file column data type as required. By changing the particular table column data type longtext(8000) to varchar(max) allowed me to transfer the SQL server data to MS Access.

It was not easy. However I was able to end it.

Endhiran a phenomenon

Date: 2 OCT 2010.

Long awaited director Shankar's & super star Rajni Kanth's movie Endhiran previewed from 30th of September 2010 world wide! It is a rush.. In Sri Lanka premier ticket shows were been sold at higher prices than ever. I am a super star fan since my childhood and I love shankar's movies. I am so enthusiast about watching the movie at first as a premier show. Somehow, I was able to secure the tickets for 9.30pm show on 30th September 2010. I am not a guy who visits theater often and staying on que to watch a movie. Most of the time invited for premier tickets. Last time was Aadhavan and that is last year.

I read some review on websites before going to the movie. They were damn good. http://roborajini.com/enthiran-news/endhiran-movie-mega-hit/ . Even though the ticket price were high, the premier shows were packed all over.

Well about the movie. The storyline is, Vasigaran the scientist (Super star) invents a Robo (Chitti) spending last 10 years which is going to be dedicated to the army to use it in the battle. As a hardwork of 10 years he sends Chitti in a real environment to test its ability and accordingly correct/upgrade/fix it.

However, Professor/Guru of Vasigaran dislikes his own student's invention as a result he disapproves the Robo as a useless machine. Since Chitti doesn't have any feelings and can't distinguish between the commands given. Even few of the events disapproves it is a useless machine.

As a result Vasi plans to fix the problem by adding feelings to Chitti and teaching him about them. However, Chitti who with the feelings now falls in love with Sana (Aishwarya Rai) who is Vasi's girlfriend. Thereafter whether Chitti able to continue his feelings of love with Sana or not is the storyline.

First part of the movie is hilarious and thrilling. As the time pasts it is more thrilling and action packed.

It is just a brief overview of the Endhiran movie by myself. :D