ssis presentation
DESCRIPTION
Examples of ETL using SSISTRANSCRIPT
OLTP Database and ETL SSIS package Barbara Bederman [email protected]
OLTP database design and SSIS ETL and database backup processThe objective was to create a OLTP database in
third normal form, and an ELT process to load data from Excel spreadsheets and XML files into the database tables. This ETL process was then packaged with a database backup, shrink and index rebuild. A job was created in SQL Server Agent to run this process on a schedule. The data was for a construction company with on-going and closed projects.
Table Of ContentsDatabase diagram of OLTP database created for this
project.Master SSIS package.Data flow for the Employee Master Load package.Data flow for the Overhead Master Load package.Control flow showing the for each container for the loading
of multiple timesheets.Data flow for the Employee Time Sheet Load package.Data flow for the Materials Purchases Load package.
(Example of an ETL process reading in an XML file)Data flow for the Invoices Load package.