Data in flat file loaded to the table but with errors. please advise how to fix it
(a) 'address' is split to 3 columns causing mismatch between the source and destination
(b) 3 Nulls in the 'B_Date' column due to different format. Do I need to massage the raw file before load into the Microsoft SQL or what is the SQL formula?