Business Intelligence And Data Warehousing Software Directory

ETL Package creation in SSIS

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:
    Categories: ETL TUTORIALS