SSIS Send Mail Task Format

I am creating a SSIS package that will basically act as an aduit for
my profiles database. I have several querys that will run and will
dump the contents to flat files. Currently if there are records in
ANY of the flat files I send an email with all of the flat files
attached. (As a side note, I would like to send just the file that
has records. Since I have several files, a like is not recomened and
I am not sure how to acomplish that. Any ideas would be helpful).

Back to the main point. The body of the email I send out, has a count
of each of the flat files with a description next to it. As it is
now, the body is pretty much one line combined. I would like to make
the format look presentable and I am not sure how to go about it.
What would be the best way to format the email and keep the count a
part of it. Any help would be great.

Thank you,

Chris.

Hello Chris:
You could build the email message using an Expression in the Send Mail Task.
Click the Expressions page, and add an expression for the property
"MessageSource".

The expression editor is a bit finnicky and you need to cast everything to
string to make it work. I have the following in an expression:

"The SSIS Package: [" + @[System::PackageName] + "] failed at " + (DT_STR,
50, 1252) @[System::ContainerStartTime] + ". The offending task was
[unknown]."

It will honor line-returns so:

"this is the first line
this is the second line"

should come out on two lines.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Chris" wrote:

> I am creating a SSIS package that will basically act as an aduit for
> my profiles database. I have several querys that will run and will
> dump the contents to flat files. Currently if there are records in
> ANY of the flat files I send an email with all of the flat files
> attached. (As a side note, I would like to send just the file that
> has records. Since I have several files, a like is not recomened and
> I am not sure how to acomplish that. Any ideas would be helpful).
>
> Back to the main point. The body of the email I send out, has a count
> of each of the flat files with a description next to it. As it is
> now, the body is pretty much one line combined. I would like to make
> the format look presentable and I am not sure how to go about it.
> What would be the best way to format the email and keep the count a
> part of it. Any help would be great.
>
> Thank you,
>
> Chris.
>