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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy