Hope someone can help.
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?
Thanks in advance.