Phil Parkin - Sunday, March 26, 2017 3:04 PM
If you have ever stored a username/password in a configuration file to be used by an SSIS package - then you know how problematic that can become. SSIS Catalog allows you to configure that information at the project or package level in the Catalog as well as overwrite/configure those values in SQL Server Agent very easily.
Another nice feature is being able to create a new project from an existing project that has already been deployed. The new project can then be modified and deployed as a different project - or as an update to the existing project.
Manually executing projects from the catalog runs those packages on the server...not on your workstation.
And finally, you have the reporting feature that is available from the catalog that will make it much easier to identify issues and see what tasks are taking the longest to process.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs