October 22, 2013 at 5:59 am
Hi all,
We've got numerous 2008 SSIS packages all using the same DB for storing package configurations within a single table. This is all fine and working well, however, I've noticed that there are a couple of configurations in the table which have the same filter, path, ValueType but different values (in this case connection strings). Here's my question - if there's more than one entry in the database table in this instance, which one does the package use?
Thanks in advance
Dave
October 22, 2013 at 6:07 am
This is a dangerous situation.
A query is issued to retrieve the configurations. If it retrieves multiple rows, all of those configurations are applied, with a configuration overwriting the previous one. In the end, the last row retrieved will set the connection.
Since you cannot influence the order in which the rows are retrieved, the result is unsure.
I would either change the filters, or use multiple configuration tables.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 22, 2013 at 6:50 am
Thanks - that's what I was afraid of...
Time to revisit some of the devs to tell them the good news 🙁
October 22, 2013 at 7:39 am
I supply all developers with a template package that has all the connections already set up with configurations. This way there is a much lower likelihood that several developers will need to create the same connection from scratch. Usually, if they do need a connection, I ask them to let me know, I add it to the template, and redistribute the template. Sounds like this process may help you a bit.
October 22, 2013 at 9:14 am
That'll be the plan (or something like that)... I'm only 3 weeks in so this is all historic... looking forward to all the other fun stuff I'll find!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply