I have multiple SQL Server 2019 instances on the same server. I’ve created and exported the first instance’s maintenance plan, edited its exported DTSX file to change the instance and plan names to avoid name conflicts, and imported the edited DTSX via SSIS (and DTUTIL) on the same server.

Problem: I see the the both the original and imported plan in SSIS under Stored Packages > MSDB > Maintenance Plans, but NOT under the second instance’s Management > Maintenance Plans list in SSMS.

Database Administrators Asked by Chad Kieffer on November 11, 2021

1 AnswersHere you go:

I believe only Windows server can have only one copy of SSIS installed. So even if you have seven instances of SQL on the same box, you'll only have SSIS devoted to one of them. SSIS will work for all them but will initially only be aware of one of them. I think the following link still holds the answer by modifying MsDtsSrvr.ini.xml to make SQL Server SSIS aware: https://www.mssqltips.com/sqlservertip/2061/how-to-manage-ssis-packages-stored-in-multiple-sql-server-database-instances/

Answered by Sting on November 11, 2021

1 Asked on July 22, 2020 by preben-huybrechts

Get help from others!

Recent Answers

- DanielWainfleet on Consider the sequence where $a_1>0$, $ka_n>a_{n+1}$ and $0<k<1$. Can we say it converges?
- JJacquelin on Differential equation, modulus signs in solution?
- N. Bar on Finding the volume when a parabola is rotated about the line $y = 4$.
- Lutz Lehmann on Differential equation, modulus signs in solution?
- Evangelopoulos F. on In a Reflexive banach space, given a closed convex set $C$ and some point $y$, there is a point in $C$, of minimal distance to $y$

Recent Questions

- Finding the volume when a parabola is rotated about the line $y = 4$.
- Differential equation, modulus signs in solution?
- Consider the sequence where $a_1>0$, $ka_n>a_{n+1}$ and $0<k<1$. Can we say it converges?
- In a Reflexive banach space, given a closed convex set $C$ and some point $y$, there is a point in $C$, of minimal distance to $y$
- Ball / Urn question with a twist

© 2021 InsideDarkWeb.com. All rights reserved.