VS2008 - SSIS Package, How to Search for a Exec SP
Posted on 2014-04-16
Hi and thanks,
I would like to find out if I can search ALL .dtsx (packages) files all at once to find were it is "exec StoredProcedure1" is located???
I want to locate the exec without having to go though every package???
I have tryed:
Click "Start," "All Programs," and click "SQL Server Management Studio." Log in with your SQL Server administrator's username and password.
Click "Server Integration Services."
Click "Stored Packages," "MSDB."
Right-click the SSIS file you want to look at and click "Export." You will be able to view your SSIS package in its XML format
But when I did the MSDB I had problems.
So I tryed:
opening the .dtsConfig file in VS2008 and that only showed me one continuse line, which was as bad as going into every package..
Maybe there is a SQL Statement I can use???