I'm really stumped on this assignment and would very much appreciate some help

Create an SSIS (ETL) Package with the following instructions

1. Load customer data from a text file to a data mart

2. Transform the customer's name to UPPER case prior to loading to the db.

3. Bad data - write to a log file

4. Good data - load into the db

Be sure to add labels to the ETL package design

Preparation:

1. Create a table to store the data

FieldName/Type:

[customerCode] [numeric](18, 0) NOT NULL,

[customerName] [nvarchar](50) NULL,

[customerUName] [nvarchar](50) NULL,

[customerAmount] [decimal](18,4) NULL,

[salesDate] [datetime] NULL,

[ETL_Load_TS] [datetime]

**Default the "ETL_Load_TS" field to the current date 2. Save the source file - Customers.txt 3. Create a blank text file called ErrorLog.txt 

Customer.Txt

CustomerCode,CustomerName,CustomerAmount,SalesDate 1001,Samuel,100.23,1/1/2017 1002,Joseph,300,2/2/2012 1003,Radhika,400,4/1/2018 1004,Tom,500,3/3/2014 1005,Mary,700,5/10/2014 1006,Randy,900,4/5/2016 1007,Shiv,1100,3/2/2018 1008,Lisa,1240,5/20/2017 1009,,1325,