Package error

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  November 25, 2019 at 12:25 pm

  #3700572

  when i ran the package through sql agent job  it got failed but i did not find any information in job history

  Executed as user: . Started: 11:59:55 AM Finished: 12:00:43 PM Elapsed: 47.281 seconds. The package execution failed. The step failed.

  How can we trouble shoot

• Alejandro Santana

  SSCommitted

  Points: 1838

  More actions

  November 25, 2019 at 12:42 pm

  #3700578

  Hello,

  I suppose you have access to the package, the only way to find out is downloading it and executing it and while you are at it, you can actually set up some logging for it inside Visual Studio.

   

• Phil Parkin

  SSC Guru

  Points: 247137

  More actions

  November 25, 2019 at 1:52 pm

  #3700589

  ramyours2003 wrote:

  when i ran the package through sql agent job  it got failed but i did not find any information in job history

  Executed as user: . Started: 11:59:55 AM Finished: 12:00:43 PM Elapsed: 47.281 seconds. The package execution failed. The step failed.

  How can we trouble shoot

  The SQL Agent job history is not the best place to look, as you have seen. Instead, check the All Executions report in the SSISDB catalog.

  ---

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  November 25, 2019 at 2:11 pm

  #3700596

  Its an sql 2016 developer edition 64 bit i did not  find any SSIS DB  i did not get any info in integration service catalogs

• Phil Parkin

  SSC Guru

  Points: 247137

  More actions

  November 25, 2019 at 6:42 pm

  #3700702

  How are you deploying your packages to the server? Are you using the project deployment model? If not, I suggest that you consider upgrading to it.

  Please read here for more information.

  ---