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

You can create a view of the sysdatabases and query the new databases created, this will allow you to schedule the dts and or create a jobs that will run as you schedule it. when querying your view if created databases are within a certain date range then email accordingly.

Jaime E. Maccou