How to save maintenance plan as a SSIS package in SQL 2008 Enterprise

• Ashif Shaikh

  Default port

  Points: 1445

  More actions

  April 22, 2014 at 7:34 am

  #290426

  Hi Experts,

  Wanted to know how to save maintenance plan as a SSIS package in SQL 2008 Enterprise, so that I can add this as a next step of SQL job..

  Regards,

  Ashif Shaikh

• Koen Verbeeck

  SSC Guru

  Points: 259015

  More actions

  April 22, 2014 at 7:46 am

  #1707763

  Log into the SSIS service, go to the folder Maintenance Plans. Find the one you need, right-click and choose "Export Package".

  Or don't export and reference it directly in the Agent job.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP