As we are aware that multiple SSIS packages can be deployed with project deployment model in SSIS 2012.
Also previously the packages were deployed to MSDB or filesystem. These options are present in 2012 too except that it has additional option to
deploy to integration services catalog database to have better visibility on logging.
After the creating of SSISDB catalog from SSMS, logging options needs be tweaked to avoid unnecessary load on the resources. Here are the options available and choose one based on the requirements.
-
Verbose : logs all the steps in the packages and it will be too noisy pretty soon.
-
Basic : logs everything except onprogress and oncustom events
-
Performance : logs only onerror
-
None
0 Comments.