SSIS: Make Excel Visible In Script Task During SQL Server Agent Job Run

  • I am wondering if I can show the Excel window when the SQL server agent job runs. The SSIS package contains a script task that opens Excel and does some formatting. I just need to monitor the formatting of these Excel files.

  • No - you cannot do this. The processes that are executed by SQL Agent are not ever associated with any display device.

  • Silly question: can't you open the Excel file yourself?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply