none
How can DTExec show the execution package progress while running it in the DOS console?

    Question

  • [SSIS 2012]

    Hi,

    We need to view the package results/progress during the execution of the package by the DTExec command. Isn´t it possible?

    The user can´t view the details for the execution by the GUI.

    The package is deployed in the SSIDB (Catalog). The final idea is to Audit the result in a *.log file from the Batch we have created. We are not considering to use the "Logging" feature while designing the package. We expect to have same SSIS events in the DOS console while executing it.

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

    How could it be possible?

    Thanks,


    Alex Berenguer

    Wednesday, February 12, 2014 9:24 PM

Answers

  • Hi Alex,

    I don’t think it is possible to display the package execution details in the Command Prompt when we execute a package stored in the SSISDB catalog. Except for enabling the package logging, we have to view the execution details from the “All Executions” Standard Report for the SSISDB Catalog.

    Regards,


    Mike Yin
    TechNet Community Support

    Wednesday, February 19, 2014 2:00 PM

All replies

  • 1 - Can try out options for DTEXEC  :

    

    2 - As mentioned above ,l there are options on SSISDB catalogue, right click , can check this Reza's blog : 

    http://www.rad.pasfu.com/index.php?/archives/78-SSIS-Catalog-Part-5-Logging-and-Execution-Reports.html

    3 - Check for SQL Server logging?


    Happy to help! Thanks. Regards and good Wishes, Deepak. http://deepaksqlmsbusinessintelligence.blogspot.com/

    Wednesday, February 12, 2014 9:36 PM
  • Hi Deepak, thanks for your attention on this.

    However,

    The user can´t view the details for the execution by the GUI.
    The final idea is to Audit the result in a *.log file from the Batch we have created.
    We are not considering to use the "Logging" feature while designing the package.
    We expect to have same SSIS events in the DOS console while executing it. Then we can log it from the BAT file.

    SQL Server logging is not being considered in this case and the ConsoleLog doesn´t show the progress during DTExec execution.

    Any other idea?

    Thanks,


    Alex Berenguer

    Wednesday, February 12, 2014 9:50 PM
  • Hi Alex,

    I don’t think it is possible to display the package execution details in the Command Prompt when we execute a package stored in the SSISDB catalog. Except for enabling the package logging, we have to view the execution details from the “All Executions” Standard Report for the SSISDB Catalog.

    Regards,


    Mike Yin
    TechNet Community Support

    Wednesday, February 19, 2014 2:00 PM