question

Robp avatar image
Robp asked

dtsx package recovery created through a Maintenance plan

I have a dtsx package I'm trying to recover from a maintenance plan. The maintenance plan was deleted, and we can't find the dtsx package. The package was created in the maintenance plan and not in SSIS or Visual Studio. It wasn't saved as an independent dtsx package on the machine. Is there a way to find where the dtsx packages are saved (and maybe they're not) if they were created by a maintenance plan in SSMS, but the maintenance plan was deleted?

maintenance-plansmaintenance
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered

If you delete the maintenance plan the underlying dtsx is also removed. You would need to restore MSDB as a user database and interrogate it to pull out the information you need.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.