I have a web application that prompts a user for some info and creates databases on the fly with VB
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.