Correcting Server Connection in Maintenance Plans

  • In SQL 2008 R2, if we clone an environment including SQL server, the maintenance plans retain a connection string to the source/original server they got cloned from and are not editable. But, I was able to use a work around by editing them in BIDS and saving them back on the server. But now with 2014, I am facing two issues:

    1.I still can edit the package to correct the server connection, with SSDT; but the option to save back to the server is not available any longer!

    2.I used to be able to see all my plans under SSIS in 2008 R2 but not in 2014 now. Although, they are listed in SSMS!

    Any clues or hints will be appreciated. Thank you!

  • I have never been able to figure this out either.

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

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