0

Spent 2 days configuring an SSIS package. Just got everything configured the way it needed to be. Noticed the package didn't have a good name so I renamed it and now is deleted!!!

Is there any way to restore this?

J.S. Orris
  • 4,653
  • 12
  • 49
  • 89

1 Answers1

1

If it's deleted from file system then there is no other way than using data recovery software. You can easily find one online (open source/trial version).

If you have deployed package before deletion then you can recover it from MSDB.

Extracting SSIS package definition from MSDB

export an SSIS package to a .dtsx file

SSIS Package Extract from MSDB

Copying SSIS packages deployed on SQL Server back to Visual Studio

Community
  • 1
  • 1
Vikramsinh Shinde
  • 2,742
  • 2
  • 23
  • 29