Copying SSIS Packages from MSDB to a Windows folder

• josetur12

  Default port

  Points: 1424

  More actions

  December 12, 2018 at 12:30 pm

  #416550

  Hi, I need to get hundreds of SSIS Packages from the MSDB database out to a Windows folder.
  The only way I know is adding one at a time to a BIDS solution.
  Does anyone know a way to copy multiple packages at the same time?

  Thanks,
  Jose

• Sreekanth B

  SSCertifiable

  Points: 6145

  More actions

  December 12, 2018 at 1:02 pm

  #2016150

  Below links should help...
  https://www.sqlservercentral.com/Forums/759424/Exporting-Multiple-SSIS-packages-from-MSDB?PageIndex=2
  http://sqlblog.com/blogs/jamie_thomson/archive/2011/02/02/export-all-ssis-packages-from-msdb-using-powershell.aspx

• josetur12

  Default port

  Points: 1424

  More actions

  December 12, 2018 at 1:21 pm

  #2016151

  Thank you, I will take a look at it.

• josetur12

  Default port

  Points: 1424

  More actions

  December 13, 2018 at 9:36 am

  #2016243

  I want to share what worked for me.
  This command, will copy the ssis package to the E drive.

  exec xp_cmdshell 'dtutil /SQL PackageName /decrypt password /COPY FILE;E:\Foldername\PackageName.dtsx'