Hi
I'm currently having a strange problem with some deployed packages (not all), where when trying to view the standard reports All executions to see the messages it doesn't show anything - I've tried with the various filters and expanding the date ranges to in the future.
I've redeployed the packages but to no success.
The development server where it was created - the messages are showing correctly.
The production server has been restarted
I've checked [SSISDB].[internal].[event_messages] table under the package_name and there are no records (development server there is)
The server is SQL server 2016 and has the most recent updates etc.
Package was originally created in VS 2017 (package configuration set to 2016)
Any help would be great
Are the packages being executed with a logging level of 'NONE', perhaps?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 9, 2021 at 12:28 pm
Yes it turns out at server level that the logging had been set to None on the production but development was set to basic - it has now been set correctly.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply