August 10, 2010 at 10:47 am
I have stored procedures that call SSIS packages. Does anyone know of a query I can use to find which SP's call which SSIS packages? I'm currently using the one below, and have tried several other things, including searching with a package name using LIKE %package_name% in syscomments.text and keep getting empty result sets. Thanks.
SELECT*
FROMsyscomments AS [sc]
JOINsysdtspackages AS [ssis]
ONsc.text LIKE ('%' + ssis.name + '%')
August 10, 2010 at 11:41 am
Have you tried the SQL search tool from RedGate? I am not sure that it will find it but I have really good luck finding a lot of otherwise obscure references. Best part is that it is FREE!!! 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 25, 2010 at 6:14 am
SELECT [ROUTINE_NAME] AS [StoredProc]
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%YourPackageName%'
AND ROUTINE_TYPE = 'procedure'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply