Automic Workload Automation

 View Only

  • 1.  SSIS package reporting

    Posted Sep 13, 2022 02:25 PM
    I am running a number of SSIS packages through a windows agent.  For older SSIS packages there would be now issue getting a report in the job showing results. I am running packages through an ISServer and get no results, the job ends almost immediately despite the package running for several hours.
    An example of Old command that shows report:  DTEXEC /DTS "&sp_EOB#" /SERVER "&dbserv#" /CONFIGFILE "\\&dbserv#\&c_EOB#" /CHECKPOINTING OFF /REPORTING V
    An example of a new command that does not get reporting:  DTexec /ISServer "\SSISDB\folder_path\package.dtsx" /SERVER "&ssisserv#" /CHECKPOINTING OFF /REPORTING V
    This is the best I get and ideally would be able to correlate the job runtime with the package runtime: 
    To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report

    Thanks!


  • 2.  RE: SSIS package reporting

    Posted Sep 14, 2022 05:06 AM
    Hi
    Try to use the following flags at the end

    SYNCHRONIZED(Boolean);True /REPORTING E

    Regards
    Klaus


  • 3.  RE: SSIS package reporting

    Posted Sep 14, 2022 08:12 AM
    I am using the following, which shows the package details with package runtime in the job report. 

    dtexec.exe /F "\\xx\xx\xx\xx\xxxx\xxx\xxxx.dtsx"  /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V /CONSOLELOG NCOSGXMT