Forum Discussion

Utham97's avatar
Utham97
Copper Contributor
Dec 06, 2022

Error in SQL jobs

Hi all,

 

Requirement is to move Dynamics CRM data to SQL

Currently we are facing the below error messages while executing the job in SQL server and in reports the status is " execution pending"

 

Error Message:

Executed as user: *****************. Microsoft (R) SQL Server Execute Package Utility Version 13.0.6300.2 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 12:20:01 PM Package execution on IS Server failed. Execution ID: 13057<c/> Execution Status:5. To view the details for the execution<c/> right-click on the Integration Services Catalog<c/> and open the [All Executions] report Started: 12:20:01 PM Finished: 12:20:02 PM Elapsed: 0.891 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0

 

Can you please advise on what could be the cause and how to solve this.

2 Replies

Sort By
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Dec 06, 2022

    To view the details for the execution right-click on the Integration Services Catalog and open the [All Executions] report

    Utham97 , first advise is to do what the message says: Lookup execution report for more details.

     

    Olaf

    • Utham97's avatar
      Utham97
      Copper Contributor
      Dec 06, 2022

      Hi olafhelper 

      Thank you for replying.

      In the execution report the status is " Pending Execution". While clicking on All messages we are unable to find any information. 

Resources