{"id":359,"date":"2013-08-17T19:05:08","date_gmt":"2013-08-18T00:05:08","guid":{"rendered":"http:\/\/www.cognitiveinfo.com\/?p=359"},"modified":"2013-08-17T19:05:08","modified_gmt":"2013-08-18T00:05:08","slug":"ssis-parameters","status":"publish","type":"post","link":"http:\/\/cognitiveinfo.com\/?p=359","title":{"rendered":"SSIS 2012 Parameters vs. 2008R2 Configurations"},"content":{"rendered":"

\"Agenda\"<\/a>
\nUpdate 8\/17\/2013: The SSIS Project downloads have been updated below.<\/em><\/strong><\/span><\/p>\n

Abstract:<\/strong><\/p>\n

In this session, Allen Smith, Business Intelligence consultant, compares SSIS Parameters in SQL 2012 to SSIS configurations in SQL 2008R2. The 2008R2 options allowed dynamic configuration across environments.\u00a0 In SSIS 2012 we review the new dynamic options, including Parameters and Catalogs. This upgrade takes SSIS from simply confusing to downright confounding. We will simplify these options so anyone with basic SSIS experience can follow along.<\/p>\n

\"\"<\/p>\n

Special thanks to our friends at GDH Consulting for hosting the December meeting of Oklahoma City SQL User Group.<\/p>\n

SQL Integration Server developers need to make dynamic changes to properties and connections when moving packages across environments.<\/p>\n

‘Configurations’ enabled SQL Integration Services 2008 R2 developers to make those changes, but it could be very confusing when multiple Configurations were used in combination.<\/p>\n

SQL Integration Services 2012 maintains support for Configurations while adding a lot of power and versatility with Parameters, Environments and Variables.<\/p>\n

\u00a0Downloads:<\/strong><\/p>\n

Presentation:\u00a0 SSIS Param VS Config<\/a><\/p>\n

Visual Studio SSIS Packages:\u00a0 SIS_Config_Vs_Param<\/a>
\n<\/em><\/p>\n

Presentation (Christmas Edition) is still available at Slideshare<\/a><\/p>\n

References:<\/strong>
\nProfessional Microsoft SQL Server 2012 Integration Services<\/a>
\nby Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock
\n2008R2 \u2013 Defining a Configuration Approach
\nhttp:\/\/msdn.microsoft.com\/en-us\/library\/cc671625.aspx<\/a>
\n2012 SSIS Parameter Basics
\nhttp:\/\/msdn.microsoft.com\/en-us\/library\/hh213214.aspx<\/a>
\n2012 SSIS Catalog Basics and\u00a0 list of stored procedures
\nhttp:\/\/msdn.microsoft.com\/en-us\/library\/hh479588.aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In this session, SQL Santa (Allen) will review configurations in SQL 2008R2. These options allowed dynamic configuration across environments. Next, we look at SSIS 2012 and the new dynamic options, including Parameters, Expressions and Variables. <\/p>\n","protected":false},"author":2,"featured_media":468,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,14],"tags":[57,74,92,93,101],"class_list":["post-359","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoftsql","category-ssis","tag-integration-services","tag-presentations","tag-sql-2008-r2","tag-sql-2012","tag-ssis"],"_links":{"self":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=359"}],"version-history":[{"count":0,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/359\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}