How to determine whether SSIS is being used?

Question

How to determine whether SSIS is being used?

jankovic

Old Hand

Points: 333
More actions
August 4, 2021 at 9:40 am

#3916796
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 3 years, 3 months ago by jankovic.

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

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

Phil Parkin SSC Guru Points: 246964 More actions · Answer 1

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.

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

AlexSQLForums SSChampion Points: 14277 More actions · Answer 2

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

Import those packages into SSIS catalog
Remove rights to share folders
Wait until their ask for it.

Alex S

jankovic Old Hand Points: 333 More actions · Answer 3

I did exactly that -

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

Thank you for the suggestions!