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 6, 2013 at 5:48 pm

    #1585168

    Below is the solution I found,I tried to raise a dialogue box through batch file after completion of the job that processes all the files in a folder1 and move it to folder2 one by one after processing.

    sqlcmd -S myserver -d "master" -Q "my_procedure"

    :loop

    ping 1.1.1.1 -n 1 -w 10000 > nul

    IF EXIST "D:\folder1\*.csv" goto :loop

    start %comspec% /c "mode 40,10&title Process Completion-Confirmation&color 1e&echo.&echo. Process has completed.&echo.&echo.Press a key!&pause >NUL"