The March 2, 2010 Meeting of the SQL Servers Innovator’s Guild will feature Processing Flat Files with SSIS as the feature presentation. When doing data integration, a common requirement is to work with flat files, whether for importing data into a system from an external source, or to export it to provide to other systems. SQL Server Integration Services (SSIS) supports flat files, but there can be a number of challenges when working with them. This is particularly true if your flat files have multiple data formats contained in a single file, the data has complex formatting, or the files have inconsistent formatting. This session will help you to be more efficient when working with these types of files. You’ll learn to handle missing delimiters in the files, and parsing files that have multiple data formats. You’ll also see how to produce complex output formats, like headers and footers that contain summary information.
Takeaways:
1. Learn to handle complex formatting in flat files
2. See the techniques to deal with poorly formatted input files
3. See the available open source components for processing flat files
via: SSIG
