Microsoft SQL server 2017 ETL project
Project stracture
SSIS tools used are following:
**Slowly Changing Dimensions
**Type1 which is Changing data without Historical Data
**Type2 with Historical data in the database if there is any changes or update
**OLEDB Command
**Parameters and Sequence in OLEDB command
**Unicode and non-unicode characters mapping between SQL server and SSIS (data conversion)
Main package includes
a)Country.dtsx
b)FactCustomer.dtsx
c)Product.dtsx
d)SalesPerson.dtsx
e)States.dtsx