Home Forums SQL Server 7,2000 SQL Server Agent Ideas welcome on SSIS jobs, Agent and kicking off another SSIS job RE: Ideas welcome on SSIS jobs, Agent and kicking off another SSIS job

  • yes i agreed with n79799,

    create a SQL job with Four Steps, first three will have the SSIS packages and the fourth one the command to update table. Make sure to set the option so that next step run only when the previous one run successfully.

    thanks

    Puneet