SSIS Project

**SSIS Project Description: Data Integration for Educational and Corporate Environments**

In this SSIS (SQL Server Integration Services) project, the primary objective is to integrate and transform data from two distinct databases, facilitating the seamless flow of information between systems. The project consists of two key packages, each designed to extract, process, and load data according to specific criteria. Here is an overview of the project's components:

**Package 1 - ITI Database Data Integration:**

*Source Database*: ITI Database

*Destination*: Two outputs - CSV file and ITI DB database

*Objective*: This package focuses on retrieving information from the ITI Database, specifically targeting students with a grade equal to or greater than 70. The results will be bifurcated as follows:

1. **CSV File**: All students who meet the grade criterion will have their names extracted and stored in a CSV (Comma-Separated Values) file. This format is chosen for its universal compatibility and ease of sharing.

2. **ITI DB Database**: Students who do not meet the specified grade threshold will be retained in the ITI DB database. This database may include additional information or serve as a repository for further analysis.

*Data Cleansing*: Duplicate values will be removed before loading the data into either the CSV file or the ITI DB database. This ensures data integrity and avoids redundancy in the outputs.

**Package 2 - Company_SD Database Data Integration:**

*Source Database*: Company_SD Database

*Destination*: Three separate text files (one for each department: DP1, DP2, DP3)

*Objective*: This package focuses on extracting information from the Company_SD Database, specifically related to employees within three distinct departments: DP1, DP2, and DP3. The extracted data will be organized into separate text files for each department.

*Data Organization*: The employees' names within each department will be compiled into distinct text files. This organization facilitates department-specific data analysis and reporting.

Overall, this SSIS project demonstrates an effective and efficient means of data integration, extraction, and transformation. It streamlines the process of collecting pertinent information from two different databases, optimally stores and formats the data, and ensures that data quality is maintained through the removal of duplicate values. The project is a valuable asset for institutions that rely on data analysis and reporting for decision-making, whether in the education or corporate sector.