SSIS Send Mail Task Format

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.
.

Relevant Pages

  • Re: Macro to Alter Table Field Names
    ... By "automation" I meant code which imports directly from (specific format) flat files (usually tab, comma or semi-colon separated), may also involve some integrity checks in the process... ... Incidentally, I was wondering the remark about automation, I think I could ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Small database recommendations ?
    ... just some organized flat files. ... > probably a database system is not really needed either, ... > text format and not binary format - plain text files can be edited in ... instead of writing custom programs. ...
    (comp.os.linux.misc)
  • Re: Small database recommendations ?
    ... > require a dbms at all, just some organized flat files. ... probably a database system is not really needed either, ... text format and not binary format - plain text files can be edited in ... Check our new Mobster game at http://mobster.td.org.uit.no/ ...
    (comp.os.linux.misc)
  • Re: Sys/36 COBOL -> AS/400 COBOL?
    ... You can continue to use flat files if you want. ... powerful features that the database and the native system have. ... Can the converted program continue to operate the same old ... files to a DB format? ...
    (comp.sys.ibm.as400.misc)
  • Re: Ping: Robert
    ... Why do you need offsets? ... for ODBC access to flat files. ... one runs 'anim (dump file name)'. ... mainframers transitioning to Unix. ...
    (comp.lang.cobol)