Actually it is easier to get all the fields to upper or lower case. 

UPPER ( character_expression )

Returns a character expression with lowercase character data converted to uppercase.

Try this to blank out  property ID of ExecutePakcageTask so when you will run the latest version.

Funcation Main()

dim objPackage

dim objTask

dim objPropertyID

set objPackage = DTSGlobalVariables.Parent

For each objTask in objPackage.Tasks

IF LEFT(objTask.Name, 30)...

Is this an old package ? Every package has version control. When you execute the package and do not clear the version, it will execute the older version.

I used to work for a company, when the supervisor interviewed people, he would ask a whole bunch of technical question about the database.  Then he would ask a IQ question...

To William Plummer: I am driving a Honda CR-X and I love it. They are still making the CR-X (the one in 2006 looks excellent) and the sale is good regardless...

Sometimes interpersonal relationship can be very subjective.  In some cases you can say it is woman intuition that I do not like some people without talking to them.

When I interview people, I...

Sorry, I still did not know what you want to do?

"IsCLIEnabled is a bit field which returns 0/1 if 1 then i check user ne jo CLI de hai...

I don't even understand what you write.

"i m still confusing how i check this ke user jo CLI enter karey woh Clis list main hai yah nahi"

check if...

You need more than that to set up a web application using SQL Server.  I recommend you hire a system archect to design the system, a SQL Server DBA, a...

Sorry

The statement should be

Update

SET

WHERE TechnicalSolution IS NULL

So I assume you want to update when TechnicalSolution IS NULL.

UPDATE RfsTrn

SET TechnicalSolution =

       CASE WHEN Recommendation IS NULL

               THEN CASE WHEN Comments IS NULL

                               THEN NULL ELSE CAST(Comments AS...

First of all, test all the queries in development before moving to production.  Backup the tables in production before doing the update.

Does the table have modifytime field so that you...

Knightbridge Solution LLC came out a white paper about Top 10 trends of Business Intelligence for 2006.  The first one is information quality.  Even if you have the best data...

I remembered reading one of Steve's article.  When you interview a person, not only the person has the right skill set, it is also important that if that person fits...

I did not lie on my resume. I never even put down the skill I have if I just attended the class or less than 6 months experience.  Actually I...