Extracting data from Source database and loading to target database

• Source database:

AdventureWorks2016_us - sql server

AdventureWorks2016_eu - mysql

AdventureWorks2016_au - postgresql

AdventureWorks2016_ca - oracle

• Target database:

AdventureWorksDW_neu: SQL Server for SSIS Target

• Load all the source files into the databases
• Install ODBC driver for MySQL, PostgreSQL and Oracle (For SQL Server, you can use the OLE DB Source and Destination)
• Connect the source files using the ODBC Data sources
• Load the source data files to all the inputand output data components
• Change the path of all the flat files

Note: Document on adding databases on ODBC drivers can be found here

• DimEmployee

• SCD type 2 in DimEmployee

• DimStore

• DimCustomer

• FactInternetSales