2005 SSIS package deployment while SQL Agent Job Running

• Marcell Abrahams

  SSC Rookie

  Points: 46

  More actions

  October 29, 2008 at 9:02 am

  #131807

  Hi all

  I currently have an SSIS package which gets scheduled on a regular basis via SQL Server Agent. This schedule is not fixed ( can be once an hour or once a minute, depending on the number of file).

  If changes need to be made to the SSIS package, is it possible to redeploy it while it is being accessed by the SQL Agent?

  Thanks

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  October 29, 2008 at 9:12 am

  #891281

  To be safe, I'd disable the job while deploying a fully tested update to the SSIS package.