SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 How to seperate one column into two
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

53 Posts

Posted - 08/27/2013 :  11:39:30  Show Profile  Reply with Quote
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 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.

Brian D. Brubaker
Business Intelligence Analyst
Viega LLC

Very Important crosS Applying yaK Herder

52325 Posts

Posted - 08/28/2013 :  01:19:01  Show Profile  Reply with Quote
use flat file source and use delimiter as (space)|(space)

SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000