April 6, 2017 at 5:36 am
Need t-sql to identify all SSIS package names in SQL 2016, SQL 2014 Integration Services Catalog's SSISDB (not msdb !!!) that reference a TABLE and/or VIEW name.
Redgate's free SQL Search does not render this info.
April 6, 2017 at 5:41 am
Although not T-SQL have a look Brandie's Detective Stories - Tracking Down the Database's Dependents Part 2, which has a section on SSIS.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 6, 2017 at 6:03 am
No good. Brandie's Detective Stories - Tracking Down the Database's Dependents Part 2 --- which has a section on SSIS --- only refers to msdb.
I need to search SSISDB. (SQL 2016, SQL 2014, SQL 2012)
April 6, 2017 at 6:07 am
Express12 - Thursday, April 6, 2017 5:36 AMNeed t-sql to identify all SSIS package names in SQL 2016, SQL 2014 Integration Services Catalog's SSISDB (not msdb !!!) that reference a TABLE and/or VIEW name.Redgate's free SQL Search does not render this info.
It's not possible, as far as I know, because package definitions are held in encrypted format in SSISDB.
An alternative is to search your VCS using some sort of file-search tool. Assuming you have a VCS and know exactly which projects have been deployed, of course.
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
April 6, 2017 at 6:18 am
Express12 - Thursday, April 6, 2017 6:03 AMNo good. Brandie's Detective Stories - Tracking Down the Database's Dependents Part 2 --- which has a section on SSIS --- only refers to msdb.
I need to search SSISDB. (SQL 2016, SQL 2014, SQL 2012)
Brandie also uses PoSh, did you try that?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply