Summary


This chapter focused on driving home the basic SSIS transforms, tasks, and containers. You performed a basic ETL procedure and then expanded the ETL to self-heal when bad data arrived from your data supplier. You then set the package to loop through a directory, find each .DAT file, and load it into the database. The finale was archiving the file automatically after it was loaded. With this type of package now complete, you could throw any .DAT file that matched the format you configured and it will load with reasonable certainty. In the upcoming chapter, you'll dive into some more advanced tasks and transforms that use the Advanced Editor.



Professional SQL Server 2005 Integration Services
Wireless Java : Developing with Java 2, Micro Edition
ISBN: 189311550X
EAN: 2147483647
Year: 2006
Pages: 182

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net