Memphis PASS Chapter

An SSIS Challenge From Brian Knight

Prove your SSIS skills by besting the experts at Pragmatic Works! This Whitepaper is designed to help you map a technical SQL Server Integration Services (SSIS) solution to a business problem. To do this, we give you a business problem to solve with loose requirements. You can then solve it however you wish inside of SSIS as long as you meet the requirements. We provide hints on how to solve the problem and if you need some more help, you can read the high-level step by step instructions. Good luck!

Download the Challenge Now!

What you’ll learn: Learn how to use the Pivot transformation Learn more about using expressions Learn more about the Lookup transformation Learn more about the Derived Column tranformation Learn more about the Conditional Split transformation Download the Challenge Now!