I have a .csv file to import into a table in a MSSQL database. The problem is the .csv file is just one columns with about 4 different fields all separted with a series of spaces.
Jon Doe NUll 12333 S1548
Mary Jane Miii 15483 E22566
and so on.
I am trying to remove the white spaces but when I use the trim feature in the DTS package I lose some data, IS there anyway to do this and get all the data at the same time?