September 23, 2013 at 11:49 am
My boss likes using the XML file based configs and passing the file in as a parameter for a DTEX command line stored in a .bat file. I kinda like the idea of putting configs in the database because it is one location I have to look at for all my settings.. At the end of the days which way is the more standard practice? Has SQL 2012 made either of those practices a better option now. Or are these outdate practices all together and I should be looking at a new way of doing them. I wish there was a poll option available.
Thanks,
Phil
September 23, 2013 at 1:19 pm
There is a poll option somewhere 🙂
There is no "industry-standard" practice on SSIS configurations, at least as far as I know.
Both have their advantages and disadvantages and in the end it boils down to personal preferences.
My personal choice also goes to the SQL Server config table, as I think it's cleaner and more UI friendlier.
In SSIS 2012 however, you have two ways of developing packages: using the project deployment model (new) or the package deployment model (old). The last one is exactly the same as in SSIS 2005/08 and you still have the choice between the different configuration options.
In the project deployment model, configurations as you know them are gone and they are replaced with parameters and environment, which are superior in my opinion.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 23, 2013 at 11:49 pm
Koen Verbeeck (9/23/2013)
In the project deployment model, configurations as you know them are gone and they are replaced with parameters and environment, which are superior in my opinion.
And in mine. I would hate to have to go back to the old way now.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 23, 2013 at 11:50 pm
Koen Verbeeck (9/23/2013)
There is a poll option somewhere 🙂
Indeed there is. The 'Add Poll' button is there for precisely this reason :hehe:
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply