How to determine whether SSIS is being used?

  • Hello

    I've inherited some dev environment which looks like was abandoned, but I'd like to make sure.

    How can I determine whether Integration services are being used?

    There are some projects deployed in Integration Services Catalog and it seems like they are not used.  select * from catalog.executions didn't return any recent executions.

    However it's a common practice here to make lives harder and execute scripts packages from shared folders using command line.

    Is there any way to capture such executions so I can ensure I can retire the server? It's version 2016

    • This topic was modified 1 month, 2 weeks ago by  jankovic.
  • Nothing obvious comes to mind.

    But as it's a dev environment, I'd be fairly brutal. Taking all of the User databases offline for a month and waiting for complaints is one technique that should work out.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

  • "However it's a common practice here to make lives harder and execute scripts packages from shared folders using command line."

    1. Import those packages into SSIS catalog
    2. Remove rights to share folders
    3. Wait until their ask for it.
    Alex S
  • I did exactly that -

    So far no concerns from users, so I'll keep it this way and see.

    Thank you for the suggestions!

Viewing 4 posts - 1 through 4 (of 4 total)

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