Home Forums SQL Server 2005 SQL Server 2005 Integration Services Dialogue box from SSIS's script task throw error when called through SSMS Job RE: Dialogue box from SSIS's script task throw error when called through SSMS Job

  • February 5, 2013 at 6:08 pm

    #1584691

    The problem here is user does not even run the job manually. She just double clicks the batch file which calls the job through Sqlcmd and then it calls the SSIS Package.

    User-> Batch File(sqlcmd)->Job->SSIS Package

    So she does not interact with job/SSMS also. She needs a little pop up which should tell her that job is completed.

    Other way is I can write a loop in job which should wait until job completes and then display a customized message in command window.

    But she does not want to run the batch file through command window even. She just need to double click the batch file and give her the dialogue box.