April 14, 2011 at 4:41 pm
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!
April 15, 2011 at 2:19 am
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
October 17, 2011 at 12:36 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply