Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is Package Configuration in SQL 2012 SSIS deprecated? Expand / Collapse
Author
Message
Posted Thursday, December 12, 2013 3:02 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 15, 2014 12:33 PM
Points: 204, Visits: 923
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.
Post #1522500
Posted Thursday, December 12, 2013 3:53 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
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
Post #1522511
Posted Monday, December 16, 2013 9:09 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 15, 2014 12:33 PM
Points: 204, Visits: 923
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
Post #1523288
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse