Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Singapore
    Posts
    7

    Question Unanswered: Create a DTS package to retrieve records from db & schedule to send the email at 9 am

    hi,
    i would like to create a DTS package to retrieve records from database , this records i retrieve is from the error log table ( ERROR_LOG_TB),the scheduler will run at 9 am daily and will retrieve the records if there is a error and the error information will be capsulate and sent through email.
    Can i know how to know how to graphically do in DTS ? i am running SQL Server 2000.

  2. #2
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    The thing that you are looking for can be done thru a "execute sql task" and using xp_sendmail. do you have any prior experience with DTS?
    -rohit

  3. #3
    Join Date
    Apr 2003
    Location
    Singapore
    Posts
    7

    Talking I got a bit prior experience in DTS

    i got some prior experience in DTS but jus not sure how to do this in graphically . programming wise i know how to do it , i just want to get some knowledge how to do it in DTS

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Get in touch with http://www.sqldts.com website which has got plenty of DTS resources and code examples.

    Also refer to books online for information about DTS as a first hand help.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •