Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
sql job getting error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote 
    Message
Executed as user: CORP\Nserver_SVC. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.5000.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  5:34:08 AM  Error: 2012-08-20 05:34:11.84     Code: 0xC002F304     Source: Send Mail on failure Send Mail Task     Description: An error occurred with the following error message: "Failure sending mail.".  End Error  Error: 2012-08-20 05:34:11.89     Code: 0xC002F210     Source: Purge PaymentAdvice And Descendants Execute SQL Task     Description: Executing the query "Exec [dbo].[PPaymentAdvAndDes] ?, Null, Null" failed with the following error: " ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  5:34:08 AM  Finished: 5:34:11 AM  Elapsed:  3.5 seconds.  The package execution failed.  The step failed.

    I am getting error on executing SSIS ->Sql job and check all need abt email

    but it was OK..

    --Himanshu Kulkarni

    Monday, August 20, 2012 11:16 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Try http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/threads

    The following is signature, not part of post
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
    Visual C++ MVP

    Saturday, September 1, 2012 1:09 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

     

    Thank you for visiting the Microsoft forum. This
    forum focuses on Perfmon and diagnostic tools. I am moving your question to the
    moderator forum ("Where is the forum for..?"). The owner of the forum
    will direct you to a right forum.

     

    Thanks.

    Bruce Adamczak


    Bruce Adamczak MCP since 1993 Please click "Mark as Answered" if a post solves your problem Please click "Vote As Helpful" if you find the answer helpful

    Friday, August 31, 2012 9:15 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Try http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/threads

    The following is signature, not part of post
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
    Visual C++ MVP

    Saturday, September 1, 2012 1:09 AM