Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    17

    Unanswered: DTS Package Error

    Hi,

    I have a DTS Package which creates a text file and then sends that file as an attachment in email using "send mail task".

    I can run this package manually but if I schedule this package, its getting failed. Here is the error message

    "DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSSendMailTask_1 DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147220352 (80040480); Provider Error: 0 (0) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 DTSRun OnFinish: DTSStep_DTSSendMailTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed."

    Could you please help me with this issue? I am using SQL Server 2000.

    Thanks!

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Have you enabled the ability to send mail ?

  3. #3
    Join Date
    Nov 2003
    Posts
    17

    DTS Package Error

    I enabled mail, but now I am getting different error message

    "DTSStep_DTSSendMailTask_2, Error = -2147220352 (80040480) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) P. The step failed."


    Thanks!

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Is sql server agent running ? And have you setup the mail profile within the agent ?

Posting Permissions

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