Henry Ji's Blog

In Javascript, if you assign a reference object to another object, you actually copy it by reference.

There are several ways to use Google custom search. One way to do it is using Search Control.

Recently I had to install SQL Server 2005 Reporting Services and thought if I summarized the things that are needed to pay attention to, it might be helpful for anyone who is in the same situation.

Normally, if a SSIS package is scheduled to run in a SQL agent job using a proxy user and this proxy user has permission to access a network drive, then there will be no permission problem for accessing files on the network drive from the control flow items in the SSIS package. However, the Bulk Insert Task item apparently works another way.

The Time Dimension filters by default appear as dropdown list boxes when designing Analysis Services reports within Visual Studio. However, users will expect Calendar controls for date filters in the reports. Here is the solution for using calendar control for date report filters.

IE and Safari support innerText property but FireFox doesn't. In FireFox, you can textContent instead as follows:

Last week there was an "Implicit conversion from data type nvarchar to money is not allowed. Use the CONVERT function to run this query." SQL bug in a web application using SQL Server 2000. The SQL error no is 257. Actually it is a known issue with SQL Server 2000 and it cannot be reproduced in SQL Server 2005. The fix is, as the message indicates, use the convert function to convert the value from data type nvarchar to money whenever you want to compare a nvarchar value with a money value or do something similiar. One example is as below -

Recently I have been working on a SQL Server business intelligence project. The client uses SQL Server 2005. I created SSAS and SSIS projects using Visual Studio 2008 with SQL Server 2008 BIDS installed but soon I found out that SSIS packages developed in Visual Studio 2008 cannot be deployed to SQL Server 2005 Integration Services due to an error – “Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported”, although SSAS project developed in Visual Studio 2008 can be deployed to SQL Server 2005 Analysis Services successfully.