• SQLRNNR (3/27/2013)


    They will not if you export as ssis packages.

    Maint plans have a lot of shortcomings. This happens to be one of them. Many DBAs use script based maintenance routines for, in part, this reason.

    Sorry - this is not quite correct. When you export the to SSIS - the type of package is still defined as a maintenance plan. If you then open the package in BIDS, change the connection information (not the name) and perform a Save Copy As - you can place the package in the Maintenance Plan folder and it will still be a maintenance plan.

    However, you have to also modify a setting in BIDS (which I cannot remember - since I haven't done it in a long time) to reset the GUID and other identifying information. If you do not make that change, the package runs - but will report failure even if all tasks are successful.

    I find it is just easier to spend the time creating the plan - which doesn't take very long and is not something I do on a regular basis anyways.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs