Tuesday, 27 August 2013

Separate one data column into two

Separate one data column into two

I am currently working with a .txt file that looks like this. (there is a
space in front of the first bracket)
| Column 0 |
| 01/01/2013 | 123.56 |
| 02/12/2013 | 25.34 |
The data is coming into SQL Server into one column. I tried to set the
delimiter to a "bar" but it still will not split the column. I assume
there is a space in the front of the bar so it is not recognizing it.
I need to separate this column into 2 separate columns one for "Date" the
other for "Total". Using SSIS, what would be the best way to do this? I
need SSIS as I will be doing some other transforms on this data once it is
separated.

No comments:

Post a Comment