You can't customize the Send Mail Task to do that, but there are a number of different approaches you can take to do this.

1) Replace the Send Mail Task in...

Take a look at this.

http://blogs.msdn.com/michen/archive/2007/03/15/ssis-debug-disabled.aspx

There are a number of ways to accomplish this. Here's one way. You'll need to do 2 things, both of which there are plenty of examples of...

What's the exact error message and where does it occur?

What is the data type of the of the column in your source query's WHERE clause?

Most likely the machine you're trying to run the package from doesn't have Integration Services installed on it.

See http://msdn.microsoft.com/en-us/library/aa337371.aspx

A Derived Column or a Script Component would work fine.

You could also create a table in your database that stores these text values with a numeric id and use a...

Check the box "Column names in the first data row" in your flat file connection manager editor's General tab.

First of all, you shouldn't be using the Active X Script component at all. This component exists only for backward compatibility with DTS.

Instead, you should be using...

Yes, you can validate the XML. Google ".net validate xml" for examples.

I don't know what your regional date settings are, but I'm going to assume that the Data Conversion component doesn't like the periods (.) in your date string.

Changing your Derived...

Yes you can. It's the first option in the configuration type drop-down box when you create a new package configuration.

Your XSD will let the XML Source know that these elements may be there.

If the elements don't exist in the XML Source, your Data Flow will not blow up because...

This should work, just keep in mind that it will store dates in GMT. In your example, 1997-10-16-04:00 will be stored as 10/16/1997 5:00 am during Daylight Savings...

Do some research on SSIS package configurations. It's exactly what you need.

http://www.mssqltips.com/tip.asp?tip=1405

If the UTC offset in your date remains -04:00, the date will default to 9:00 pm the previous day in the Pacific time zone only while you're in Daylight Savings...