Hi. I'm having trouble figuring out how to do this assignment. Please help. Thanks.

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

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,