I have a web application that prompts a user for some info and creates
databases on the fly with VB.NET.

Multiple databases can be created in one day. I need to create a DTS package
that will be scheduled to run daily. This dts gathers some info on each
database that got created. For example, 5 databases were created.

The DTS creates an email with some statistics in the body of the email and a
csv file attachment of some info from the databases. At this point I haven't
decided (or actually wasn't told by my manager) if the package should create:

1. separate emails (in this cases 5 emails) with the csv file attached to
each email and stats in the body OR


2. one email with 5 attachments (for each db) and stats of all 5 dbs in the
body OR

3. one email with one attachment, but 5 worksheets and stats of all 5 dbs in
the body.

Are all of these scenaries possible within a DTS package. Remember, I won't
know how many databases were created. I'd have to figure that out dynamically.


Thanks,
Ninel

--
Message posted via http://www.sqlmonster.com