Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 22nd, 2006, 10:33 AM
Authorized User
 
Join Date: Mar 2005
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multiple emails with one DTS package

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



 
Old October 23rd, 2006, 08:00 AM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with DTS PACKAGE mxwebb SQL Server DTS 1 November 28th, 2007 05:16 PM
Sending Html Emails through DTS cvnitkumar SQL Server DTS 1 January 9th, 2007 01:00 PM
Check Multiple running Instance of DTS Package greenash SQL Server DTS 0 January 3rd, 2005 09:33 AM
Scheduling DTS Package chiefg SQL Server DTS 11 April 30th, 2004 11:18 AM
DTS Package Deployment acdsky VB Databases Basics 1 February 22nd, 2004 12:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.