Cool Tricks to Pull From Your SSIS Hat
Presenter: Julie Smith
SQL Server Integration Services-Variables, For Each Loops, and the SSIS Expression Language. This presentation is geared toward the developer who is relatively new to SSIS, has mastered the basics of the dataflow, and is now looking for elegant ways to automate his/her solutions. It introduces essential components to sophisticated ETL design. The presentation demonstrates several uses of variables, types of variables (including the SSIS workhorse ado.net object), and various ways to populate them. The session will also cover the basics of the SSIS Expression language. This session is demo intensive, using case studies of real business problems.
About the Speaker
Julie Smith has spent the last 11 years moving data using varied tools such as MS Access, MySQL, and most importantly SQL Server 2000-2008. She is an MCP in SQL Server 2000: Implementing Database Design. She has worked for a major law firm and a major compliance reporting company. She currently works as a Business Intelligence Consultant for Key2 Consulting, LLC in Atlanta, GA.