Step 1: Create an Input, drag and drop CSV File Input from Input step into your Transformation.
Right click, edit the Input file.
Provide File Name, click on Get Fields, then Preview to have a look in your input file.
Double check the file type, format and length.
Step 2(optional): To add any transformation such as Sort rows, Calculator, Add Constants etc., expand transformation and select the choice.
Step 3: Create an Output, drag and drop Table Output from Output step into your Transformation.
Create a DB Connection.
Create Table in DB.