DTS send mail task hangs

Posted on 2005-04-13
Last Modified: 2013-11-30
I am trying to send an email using the send mail task in DTS. I am using OUTLOOK.   Both the SQL SERVER service account and the Agent account are domain accounts.  Both accounts are local administrators on the box and are mapped to the sysadmin

  Email  alerts work- I get the email from SQL SERVER AGENT.
  Emails requested at the end of a scheduled DTS package work fine.
  Emails from  a send mail task within a DTS work if the package is not scheduled
However, Emails from  a send mail task within a DTS fails if the package is scheduled
Question by:mise13
    LVL 9

    Expert Comment

    turn on package logging and post the send mail error.

    Author Comment

    For anyone else having this problem- the final answer was provided by Microsoft Support.  It was a MDAC version problem, resolved by installing sp of Windows Server 2003

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now