Summary
Having used lots of Data Flow transformations, you must by now feel a lot more confident and ready for real life challenges. You have used various transformations to perform functions such as pivoting, sorting, performing an exact lookup for de-duplication of data, and standardizing data, fuzzy lookup, and fuzzy group to eliminate duplicates in a pipeline, aggregate data, and load a slowly changing dimension table. You’ve also studied several other pre-configured transformations that are straightforward to use in your packages. Having come so far, you can now create control flow and data flow in your packages to perform workflow and transformation functions, store and manage your SSIS packages, and secure them as well. This chapter ends ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
