You could also use multiple derived column components to keep your expression simple. Put each case into it's own derived column and put them in the correct order.

I cannot...

If you can use a lookup - use a lookup. Remember, you don't need an actual table for a lookup - your query could simply be a bunch of...

I beat you and John to it today.

You could use the command line tool. Before going that direction, you may want to consider adding a linked server to the remote server. You would then be...

First, to handle your simple example, you could create a table that had "MyValue" and "MyOutput" as columns and simply use a lookup component. Not only would this be...

Shrinking the log does not impact the log chain, but truncating the log does.

Log files don't shrink much unless you just did a log backup or truncated the log.

Lynn Pettis (1/15/2009)

---

Not to hijack the thread for something totally unrelated, but....

Gail, according to your web site you've done web development at one time, so I have a very basic...

2 weeks? It sounds like you and I work at the same company.

We do use VMWare for our development environment. For a new SQL server we have two...

SSIS allows pretty extensive error handling within the package. Is there something specific you are trying to deal with?

As far as tracing - turn on logging by right-clicking in...

Some people have had good luck with it. Some have not.

I have had some bad experiences with it on a few development servers. Problems with low-level issues like...

Matt Miller (1/15/2009)

---

Steve Jones - Editor (1/15/2009)

---

Well it is steel, and likely move's fast in Gail's hands, but no, it's not a bike.

http://en.wikipedia.org/wiki/Katana

Got to play with sticks last night, Filipino...

When a database has to grow due to a transaction, it has to request the space from the operating system and then expand the file. This can be a...

That point gets missed by a lot of people.

One thing to note. If you use the SQL Server destination component, the SSIS package must be running on the SQL Server that is the target. It must...

You probably want to use Full-Text indexing for searches like this. It would be good for you to look up the topic in books online and get familiar with...