May 6, 2023 at 2:37 am
Hi everyone
I am having some issues with SSIS logging. I recall setting it up but I don't remember how I did it last time. It was an option in SSIS somewhere but I cannot seem to find it now. I took a look at sysssislog table and I see that it did log in the past but stopped recently. I am not sure why it stopped. What could be some reasons why it stopped?
Thank you
May 6, 2023 at 6:39 am
Are your packages deployed to SSISDB?
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
May 8, 2023 at 8:53 pm
Sorry - but no idea on why the SSIS package is no longer logging. There could be many reasons - but I would start with the config file to see if there are any configuration items that control logging. I would then look at the agent job (if running through the agent) and check there - and I would validate that the job is actually running and completing successfully.
The next thing I would do is create the integration services catalog on the server where that package is executing. Then I would take the time to convert the package deployment to a project deployment (removing the logging configuration) and deploy to the catalog. Let the catalog manage the logging for you - which removes a whole level of complexity to your packages that just isn't needed.
When converting to project deployment - evaluate whether you need to do everything in that one package as a single package. In many cases, breaking the package up into parent/child packages is much easier to manage and maintain and often makes for much simpler packages.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply