How to download SSIS Packages from SSISDB

sql-server ssis ssis-2012 ssis-2014
Rich Uchytil picture Rich Uchytil · Nov 25, 2017 · Viewed 11.1k times · Source

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!

Answer

Joost picture Joost · Nov 25, 2017

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

Related questions

SSIS Package not wanting to fetch metadata of temporary table

I have an SSIS Package, which contains multiple flows. Each flow is responsible for creating a "staging" table, which gets filled up after creation. These tables are global temporary tables. I added 1 extra flow (I did not make the package) …

Read More
SSIS 2012 Method not found: void

I recently got this error in every SSIS package (using Visual Studio 2012), when I want to open a OLE DB source component: =================================== Method not found: 'Void Microsoft.DataTransformationServices.DataFlowUI.DataFlowConnectionPage.set_DataPreviewTimeout(Int32)'. (Microsoft Visual Studio) ------------------------------ Program Location: …

Read More
Is there any releavance for "ROW PER BATCH" AND "MAX INSERT COMMIT SIZE" IN SSIS PACKAGES?

I've have SSIS Package that is exporting 2.5 GB OF DATA containing 10 million records into Sql Server Database which has 10 partitions including PRIMARY FILE GROUP. Before Changing default Max Insert Commit size i.e."2147483647" and Row per batch.It was taking 7 …

Read More