My company have an SSIS package that has been running nightly for about five years without issue.
An internal audit recently revealed that due to staff leaving, there's actually no-one left in the building who knows what this package actually does.........and, bad news for me, I am deemed the most "competent" to deal with it so it's washed up on my beach.
The last time I had anything to do with SSIS packages was back in the day when you used BIDS to do these things.
Apparently these days you use Visual Studio with a plug-in?
For clarity, we're talking about opening solutions and then seeing workflow style diagrams.
Are there any good tutorials / sample packages out there that any of you would recommend?
Make a copy and then try to open it with Visual Studio. If the version of VS you have is newer, it may ask you to upgrade the package. You can edit the SSIS package using a text editor and look for the Package Format Version, which would tell you which version of Visual Studio it was built with. You may need to search the web for package format version to VS version translation.
With the Package deployment model you can save the package from msdb to the file system if it's stored in SQL Server or make a copy of the package file, create a new SSIS Project and remove (delete) the default package, add the Existing Package and select the copied save file.