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