Search for Variables
-
I need to update the logic of a variable in an SSIS package which has around 100 tasks in it. So i need to know in what tasks that variable is being used.
Instead of opening each and every task and look for that variable, is there a quick way to search for that variable without having to open each and every task?
Thanks in advance!
-
You can search the XML file for the variable.
(the .dtsx file is actually just XML)
On a sidenote:
it is a best practice to keep your packages small and modular. Just to avoid problems like this
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Thanks a lot!! That suggestion helped me a lot in finding out the tasks in which the variables are being used.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply