December 12, 2013 at 3:02 pm
Most of our SSIS packages written in BIDS for SQL 2008 use Package Configuration where the values are pulled from either a configuration table, XML, or an Environmental Variable on the OS, but when these are converted to SQL 2012 and converted to Project Deployment Model the variables in Package Configuration are just converted to Parameters and the process that updates these values from the external source is lost.
So is Package Configuration deprecated? I understand the new model in SSISDB with Environments and so forth, but given our original standard was that all SSIS packages pulled from a central configuration table this seems to be impossible to do with Project Deployment in SSIS on SQL 2012. Also I've tested deploying the Packages to SQL outside of SSISDB which does maintain the Package Configuration options, but then we loose the benefits that come with SSISDB in SQL 2012.
Probably just have to weight the benefits of each, but I'm just curious if there's been any talk at MS about Package Configuration being deprecated where eventually Project Deployment will be the only option.
Thanks.
December 12, 2013 at 3:53 pm
Deprecated yes, unavailable NO, you can still get to the configuration. In the properties of the package there is a line labeled Configuration and an ellipsis to far right, click on that and the familiar modal window will come up. I think there is a setting somewhere else to show it but I can't find it in Visual Studio 2010 at the moment..
CEWII
December 16, 2013 at 9:09 am
Elliott Whitlow (12/12/2013)
Deprecated yes, unavailable NO, you can still get to the configuration. In the properties of the package there is a line labeled Configuration and an ellipsis to far right, click on that and the familiar modal window will come up. I think there is a setting somewhere else to show it but I can't find it in Visual Studio 2010 at the moment..CEWII
I had no idea this was there... Thanks.
Sam
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply