I was wondering if there was a way to import data using a pipeline delimiter instead of a comma, as I seem to be getting nulls in certain areas.
Right-click on the CSV file in the data source pane --> Go to Date Properties
change the below parameters as you wish
Field Seperator you can select other in the drop down give as per your file and if you have text qualifier you can mention the same as well
if this answer helped kindly mark it as correct or helpful so that it will help others