Business Intelligence And Data Warehousing Software Directory

ETL Package creation in SSIS
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:
    docs.microsoft.com/en-us/sql/integration-services/ssis-how-to-create-an-etl-package
    Categories: ETL TUTORIALS