{"id":1090,"date":"2015-04-29T15:47:19","date_gmt":"2015-04-29T15:47:19","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=1090"},"modified":"2024-01-06T16:43:44","modified_gmt":"2024-01-06T16:43:44","slug":"may2015-the-powershellssis-smack-down","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=1090","title":{"rendered":"May-2015~ The PowerShell\/SSIS Smack Down!"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2013\/03\/BryanCafferky.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-thumbnail wp-image-453\" title=\"Bryan Cafferky\" alt=\"\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2013\/03\/BryanCafferky.jpg\" width=\"120\" height=\"120\" \/><\/a><\/p>\n<p><span style=\"color: #800000;\">Presenter:<\/span> Bryan Cafferky<br \/>\n<span style=\"color: #800000;\">Topic:<\/span> The PowerShell\/SSIS Smack Down!<\/p>\n<p>Step aside SSIS, there\u2019s a new player in town.  PowerShell and it can do anything SSIS can do and more.  In this presentation, we will consider the merits of PowerShell as an ETL tool versus SSIS.  We\u2019ll discuss a simple ETL framework using PowerShell created custom objects that extract data from a number of sources, transform it, and load it into database tables. We\u2019ll see how PowerShell can deliver a high level of extensibility and reusability unmatched by SSIS.  Concepts will be made clear by applying them to a use case of a fictitious company\u2019s data warehouse load.  You may leave the meeting thinking it\u2019s time to switch ETL tools.<\/p>\n<p><span style=\"color: #800000;\">Biography:<\/span><\/p>\n<p>Bryan has been working in data warehousing for over two decades and on the Microsoft SQL Server stack for twenty years.  He founded and leads PASS chapter, The Rhode Island Microsoft Business Intelligence User Group.  Bryan is a frequent speaker at SQL Saturday\u2019s, PASS Chapter meetings, Code Camps and anywhere he can share knowledge.  He holds a bachelor degree in Computer Information Systems and a Masters of Business Administration.  He is currently working on a book entitled PowerShell for Database Developers to be released in 2015.  Most importantly, Bryan is always eager to learn new things. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Presenter: Bryan Cafferky Topic: The PowerShell\/SSIS Smack Down! Step aside SSIS, there\u2019s a new player in town. PowerShell and it can do anything SSIS can do and more. In this presentation, we will consider the merits of PowerShell as an ETL tool versus SSIS. We\u2019ll discuss a simple ETL framework using PowerShell created custom objects [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[183],"tags":[],"class_list":["post-1090","post","type-post","status-publish","format-standard","hentry","category-2015-events"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1090"}],"version-history":[{"count":2,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1090\/revisions"}],"predecessor-version":[{"id":1112,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1090\/revisions\/1112"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}