I transfered a maintenance plan using the method to transfer ssis with sql server management studio.
The sql task contained in my maintenance plan are set to use the "local server connection".ÃÂ Somehow, when I run the maintenance plan on the target server, the sql task get executed on the source server from which I imported the maintenance plan.
In other words:
I transfer a maintenance plan from server A to server B.
The maintenance plan is set to use local server connection.
Running the maintenance plan on server B affects the server A instead of the server B.
Is there a way toÃÂ refresh or repairÃÂ the "local server connection" so that it actually connect to the current server instead of the one the ssis was imported from.
Here are some references on the method I used.
View Complete Post