This is SQLServer 2008.
Here's what I did:
There are no error messages, yet the maintenance plan doesn't get created on Server B. Am I missing something fundamental about what SSIS packages are about?
The plan consists of a shrink db step, several TSQL steps and the run an agent job step. In the .dtsx file I can see all of those.
I chose the option "do not save sensitive data" but I'm not aware of any in the plan.
Are you talking about the maintenance plan package created by the SQL Server Maintenance Wizard?
The package supposed not to create them, execute rather.
Arthur My Blog
- Proposed as answer by ArthurZMVP, Moderator Monday, December 03, 2012 2:54 PM
If I understand your problem, I believe that there is a little more to do.
I suggest that you read this: How to: Create Multiserver Maintenance Plans
Perhaps that will help you get it working.
As an aside, not the question you asked, also read: Why you want to be restrictive with shrink of database files
No, I didn't use the Wizard, I just chose "new maintenance plan" and created it using the tool you get when you choose that menu option.
I didn't realise the package wasn't for creating them. So it can't be done I guess. I'll have to create a new one by hand.