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

  • Thanks guys. I've implemented the jobs as one big job and they wait for each step to complete. I dont have any more locks, but now I find that I do have a problem with the time it takes to load of the data itself.

    I need to load the data and also export part of it again to downstream databases. Im running in to problems with it, but I'l going through all the loading steps and checking on how to speed up the loading, i.e. disabling index, using bulk loads, change updates and inserts to merges etc.

    I guess I cant have your cake and eat it...