Post reply

SSIS Logging

  • May 6, 2023 at 2:37 am

    #4185062

    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

     

    • This topic was modified 2 years, 2 months ago by water490.

  • May 6, 2023 at 6:39 am

    #4185131

    Are your packages deployed to SSISDB?

  • May 7, 2023 at 12:38 am

    #4185427

    Phil Parkin wrote:

    Are your packages deployed to SSISDB?

    No they are not.  I never did that before and the logging was working then.  No clue what happened that cause it stop logging.  Any suggestions?

  • May 8, 2023 at 8:53 pm

    #4186274

    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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy