SSIS naming conventions in a nice copy paste format

I do love a naming convention 🙂 and I’m a big fan of the SSIS naming conventions for tasks and I tend to keep these inside a template package so I don’t have to try to remember them all. Problem is if I’m on a client site I can’t use my template and so I have to pull them from the web. Most sites list these naming conventions in tables and it doesn’t quite work for SSIS’ text blocks.

Moving system databases

Three different approaches depending on the database being moved. Whilst this not required, it’s a good idea to perform these actions one database at time in case of encountering issues.