Maintenance Plan SSIS Packages fails on the exported server

  • Hi All,

    I have created a maintenance plan with package configurations. Exported that to a server and imported there. But, when I open the maintenance plan (either in the Management Studio or the Business Inteligence Development Studio), and try to edit, I get the below error.

    Collection cannot be null. Parameter name: c (mscorlib)

    I checked the connection string and other parameters and everything is fine. When I execute the plan too, this error is thrown.

    I traced this to be related to some post SP2 hotfixes (http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1456524&SiteID=17), but is there a work around this problem? I need to get this work urgently and so cannot search for the correct hotfix(es).

    Can anyone please help here?

    Thanks a lot,

    Manoj Deshpande.[/font]

  • I've always had trouble with maintenance plans once I edited them in BIDS. After that point, I've managed them as normal SSIS packages, not plans anymore.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply