PPT-Upgrading SSIS Packages to SQL Server 2012

Sven Aelterman Lecturer in Information Systems amp WebTechnology Specialist Troy University Sorrell College of Business DBI329 Scenario for T his Session Using SQL Server 20052008 Integration Services. Phil Brammer. Phil Brammer. Over 10 years’ experience in database technologies, data warehousing, ETL, on-call…. Started on Red Brick Data Warehouse. Ralph Kimball’s product. . Inmon. Who?. Worked with Teradata at PayPal. SSIS Packages from 2005 to 2008. Lessons Learned. David Cobb. MCT, MCITP SQL . DBA,Dev,BI. MCSE,MCAD. david@davidcobb.net. How do I migrate. SSIS Packages from 2005 to 2008. Just ask. MSDN. http://msdn.microsoft.com/en-us/library/cc280546.aspx. Wouter Smit. About the Speaker. Wouter has been working in the data warehousing field for more than 10 years. MCITP Professional . Database Administrator. Database Developer. Business Intelligence Developer. Speaker Name. Title. Email. Microsoft Corporation. Dan Stolts. , MCT, MCSA, MCITP, MCSE…. Microsoft – . Chief Technology . Strategist. http://ITProGuru.com. @. itproguru. CT, MA, ME, NH, VT, NY (upstate). R2 . and SQL Server Code-Named . “. Denali”: A Comprehensive . Look. Peter . Saddow. (petersad@microsoft.com). Senior Program Manager. Microsoft. DBI319. Agenda. Upgrade Planning. Upgrade Strategies and Considerations. Dandy . Weyn. DBI335. Dandy Weyn. dandyw@microsoft.com. www.ilikesql.com. @. ilikesql. AlwaysOn. Reliable . Secondaries. FileTable. xVelocity. 15k Partitions. SQL Server Data Tools. Power View. BI Semantic Model. Erik Veerman. Mentor, Solid Quality Mentors. SQL Server MVP. 2. SQL Server MVP (Most Valuable Professional). Mentor with Solid Quality Mentors. ~15 years in the industry, 10 years SQL Server BI experience (v1 SQL BI, beta SQL 7)… Telco, Manufacturing, Finance, Insurance, Retail, Real Estate…. bknight@pragmaticworks.com. HR Departments are no fun.. Don’t mention the stalking incident with Clay Aiken. What happened in . Vegas. My prom date with a puppet. Most unfortunate incident with a turtle. Phil Brammer. @. PhilBrammer. ssistalk.com. Phil Brammer. Over 12 years’ experience in database technologies, data warehousing, ETL, on-call…. Started on Red Brick Data Warehouse. Ralph Kimball’s product. . Andy Leonard. SQLBits 9. 1 Oct 2011. Europe’s Premier . Community . SQL Server Conference. #. SQLBITS. Platinum Sponsor. Premium Sponsor. Please visit our Gold Sponsor stands,. we couldn't do it without you…. David Faibish, Senior Program Manager. SQL Server Data Quality Services. Microsoft . SQL Server 2012. Agenda. The Business . Case. DQS . Component Overview. Configuring the DQS Component. Demo. Tips and Best Practices . Email: ggable.it@tig313.com. LinkedIn: linkedin.com/in/tig313. This presentation shows the basics of SSIS to help with automating database tasks, such as maintenance, importing and exporting data, or ETL transactions. The discussion will start with an understanding of when SSIS should be used vs. when a database object, such as a view or stored procedure, should be used. You will also see how to create a basic package, how to use the built-in logging and configurations, and a view of a decent sized ETL used for creating a data warehouse for BI. Lastly, we will talk about the different ways SSIS is used, based on the role of the person using it and the importance of organizing the overall SSIS structure.. SSIS Parameters vs. Configurations New tricks in 2012! Allen Smith Sr. Business Intelligence Consultant Cognitive Information, Inc. Specialize in BI and Data Warehousing since ‘99 Healthcare I nsurance SSIS for Absolute Beginners by George SQ UI L LACE “ SQL ” is in the name! CuriousGeo@e-Squillace.com August 20, 2015 Speaker Background Husband, Dad MCT MCSE SQL Server 2012 MCSA MCSE: Data Platform