ETL Package creation

Business Intelligence And Data Warehousing Directory

ETL Package creation
Preview:
Details:	The tutorial shows how to create a simple ETL Package using graphical tools and wizards of SSIS Designer - Microsoft SQL Server 2005 Integration Services. The tutorial illustrates how to use various features of SSIS such as: Creation of the basic ETL package - which takes data from a flat file, reformats the data using lookup transformations and then inserts the reformatted data into a fact table. Looping is added to the default ETL package which helps extract multiple flat files into a single data flow process Package configurations, logging and error handling
Address:	http://msdn2.microsoft.com/en-us/library/ms169917.aspx
Categories:	ETL TUTORIALS
BI DW Rating:	3