 | |
How to find TSQL Code in SSIS Packages
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: How to find TSQL Code in SSIS Packages -
08-08-2008
, 07:46 PM
|
Hi, Cqlboy wrote: I've got > 300 very complicated SSIS packages which execute TSQL and stored procedures. SSIS Packages are executed by jobs and some are executed manually. At various times I have issues with executing spids and need to hunt down offending code. I can get to the TSQL command via DMV's but how do I find which SSIS Package(s) contains the offending code? What if I have a stored procedure that, for whatever reason, I have to locate all references, i.e. sp_send_dbmail. Is there a better way than opening up 300+ SSIS packages and going through them with a fine tooth comb? Whew ! What a lotta' work. Is there somewhere I can just query the syscomments table for SSIS Packages ??? Thanks. -CqlBoy dtsx-files are xml-files. So you can use any tool which supports searching for text in several files, e.g. grep, find or a good text editor, e.g. notepad++ hth, Gerald |
#12
| |||
| |||
|
|
Hi, Cqlboy wrote: I've got > 300 very complicated SSIS packages which execute TSQL and stored procedures. SSIS Packages are executed by jobs and some are executed manually. At various times I have issues with executing spids and need to hunt down offending code. I can get to the TSQL command via DMV's but how do I find which SSIS Package(s) contains the offending code? What if I have a stored procedure that, for whatever reason, I have to locate all references, i.e. sp_send_dbmail. Is there a better way than opening up 300+ SSIS packages and going through them with a fine tooth comb? Whew ! What a lotta' work. Is there somewhere I can just query the syscomments table for SSIS Packages ??? Thanks. -CqlBoy dtsx-files are xml-files. So you can use any tool which supports searching for text in several files, e.g. grep, find or a good text editor, e.g. notepad++ hth, Gerald |
#13
| |||
| |||
|
|
Hi, Cqlboy wrote: I've got > 300 very complicated SSIS packages which execute TSQL and stored procedures. SSIS Packages are executed by jobs and some are executed manually. At various times I have issues with executing spids and need to hunt down offending code. I can get to the TSQL command via DMV's but how do I find which SSIS Package(s) contains the offending code? What if I have a stored procedure that, for whatever reason, I have to locate all references, i.e. sp_send_dbmail. Is there a better way than opening up 300+ SSIS packages and going through them with a fine tooth comb? Whew ! What a lotta' work. Is there somewhere I can just query the syscomments table for SSIS Packages ??? Thanks. -CqlBoy dtsx-files are xml-files. So you can use any tool which supports searching for text in several files, e.g. grep, find or a good text editor, e.g. notepad++ hth, Gerald |
#14
| |||
| |||
|
|
Hi, Cqlboy wrote: I've got > 300 very complicated SSIS packages which execute TSQL and stored procedures. SSIS Packages are executed by jobs and some are executed manually. At various times I have issues with executing spids and need to hunt down offending code. I can get to the TSQL command via DMV's but how do I find which SSIS Package(s) contains the offending code? What if I have a stored procedure that, for whatever reason, I have to locate all references, i.e. sp_send_dbmail. Is there a better way than opening up 300+ SSIS packages and going through them with a fine tooth comb? Whew ! What a lotta' work. Is there somewhere I can just query the syscomments table for SSIS Packages ??? Thanks. -CqlBoy dtsx-files are xml-files. So you can use any tool which supports searching for text in several files, e.g. grep, find or a good text editor, e.g. notepad++ hth, Gerald |
#15
| |||
| |||
|
|
Hi, Cqlboy wrote: I've got > 300 very complicated SSIS packages which execute TSQL and stored procedures. SSIS Packages are executed by jobs and some are executed manually. At various times I have issues with executing spids and need to hunt down offending code. I can get to the TSQL command via DMV's but how do I find which SSIS Package(s) contains the offending code? What if I have a stored procedure that, for whatever reason, I have to locate all references, i.e. sp_send_dbmail. Is there a better way than opening up 300+ SSIS packages and going through them with a fine tooth comb? Whew ! What a lotta' work. Is there somewhere I can just query the syscomments table for SSIS Packages ??? Thanks. -CqlBoy dtsx-files are xml-files. So you can use any tool which supports searching for text in several files, e.g. grep, find or a good text editor, e.g. notepad++ hth, Gerald |
#16
| |||
| |||
|
|
Hi, Cqlboy wrote: I've got > 300 very complicated SSIS packages which execute TSQL and stored procedures. SSIS Packages are executed by jobs and some are executed manually. At various times I have issues with executing spids and need to hunt down offending code. I can get to the TSQL command via DMV's but how do I find which SSIS Package(s) contains the offending code? What if I have a stored procedure that, for whatever reason, I have to locate all references, i.e. sp_send_dbmail. Is there a better way than opening up 300+ SSIS packages and going through them with a fine tooth comb? Whew ! What a lotta' work. Is there somewhere I can just query the syscomments table for SSIS Packages ??? Thanks. -CqlBoy dtsx-files are xml-files. So you can use any tool which supports searching for text in several files, e.g. grep, find or a good text editor, e.g. notepad++ hth, Gerald |
#17
| |||
| |||
|
|
Hi, Cqlboy wrote: I've got > 300 very complicated SSIS packages which execute TSQL and stored procedures. SSIS Packages are executed by jobs and some are executed manually. At various times I have issues with executing spids and need to hunt down offending code. I can get to the TSQL command via DMV's but how do I find which SSIS Package(s) contains the offending code? What if I have a stored procedure that, for whatever reason, I have to locate all references, i.e. sp_send_dbmail. Is there a better way than opening up 300+ SSIS packages and going through them with a fine tooth comb? Whew ! What a lotta' work. Is there somewhere I can just query the syscomments table for SSIS Packages ??? Thanks. -CqlBoy dtsx-files are xml-files. So you can use any tool which supports searching for text in several files, e.g. grep, find or a good text editor, e.g. notepad++ hth, Gerald |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.