Data Pipline SSIS package
Data Pipline SSIS package
This Project is about building a pipeline to ingest the Car Sales data to the database from multiple source files consolidate them in one large Database for Ready analysis.
Output of the Package with new derived columns Brand & ZAR Price
Step1 .Raw Data to load
Step 2. View Structured CSV Data
Step3. Loop container to go through CSV files
Step 4 Defining File source & Derived Column
Step 5. Defined Destination source & connections
Step 6. SSIS Package Executed/Ran