Data Pipline SSIS package
Data Pipline SSIS package
Embedded Files
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
There 6 Steps that are considers to make sure the pipeline runs succesfully, the output is in the bigger picture above when all the Data in the SQL Sever Database.
There 6 Steps that are considers to make sure the pipeline runs succesfully, the output is in the bigger picture above when all the Data in the SQL Sever Database.
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
Page updated
Google Sites
Report abuse