How to download SSIS Packages from SSISDB
Here are a couple of options to download packages (projects) from the SSISDB http://microsoft-ssis.blogspot.com/2016/04/get-packages-from-ssis-catalog.html
Rich Uchytil
I've worked in IT in one way or another my entire career. Everything from database development/administration, reporting, ETL, general IT daily support, unix & windows scripting to analyst working with users to develop requirements, and a bunch of other things. I consider myself a well rounded IT person who understands most aspects of IT quite well. Outside of work I play trumpet, enjoy craft beer, photography, hiking, various computer games, reading, and spending as much time as I can with my wonderful family. I don't know everything but my Google-Foo is strong. I learn something new almost every day - many times thanks to StackOverflow! I may ask a stupid question, but just remember, at one point we all said, "What's a hard drive?" Be patient with me, I'm always learning and hopefully won't ask the same stupid question twice. ;)
Updated on June 09, 2022Comments
-
Rich Uchytil almost 2 years
I'm still fairly new to SSIS. I've figured out how to download packages from a server by connecting to Integration Services. How do I download packages from SSISDB? Background: We have a TON of packages that the previous people created. All packages SHOULD be kept in the same folder structure on our shared drive. However, there are cases where the package that is in the database is newer than the one on the shared drive. I want to be able to look at the installed packages to see if they match what's on the shared drive, and if the installed version is newer edit that version. Thanks!
-
Rich Uchytil over 6 yearsAwesome!! Thanks very much!!