June 18, 2014 at 2:54 am
I have setup few packages with package configurations. Some are not without configuration. Can i find which packages are using configurtions and which are not?
Configuration variable values are stored in sql table.
June 18, 2014 at 2:56 am
You'll need to open each package and look at the configuration properties.
Or learn how to parse the XML behind the SSIS packages for a certain value.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 5:07 pm
The Configuration Table can't be used for detection because Configurations can be re-used between packages. You can't rely on it.
There's really no way around it, you have to either get the XML for all the packages, or load them up in VS/BIDS, and look.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 18, 2014 at 11:57 pm
An alternative is to run all the packages and use SQL profiler to monitor which packages make connection to the configuration table.
You know, why keep things simple? 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 19, 2014 at 1:12 am
Rename the configuration table and see which packages fail when executed! 😉
June 19, 2014 at 1:17 am
Lempster (6/19/2014)
Rename the configuration table and see which packages fail when executed! 😉
I like the way you think, but this doesn't necessarily lead to failures.
If a package configuration fails, the package throws a warning but resumes with the defaults specified during design time.
So it only fails if you specified invalid connections at design time.
Or you could monitor for the validation warnings.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 20, 2014 at 4:30 am
Reading the package XML is the workable solution. Starting to work on it.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply