Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Parse value

Author  Topic 

Brittney10
Posting Yak Master

154 Posts

Posted - 2014-06-14 : 14:18:37
I'm needing to parse a value in a derived task that looks something like this "123_abc_0_defg". The values are delimited by the "_" (underscore) and I need each value to be their own separate field. There is no set size for the values, so it can't be based on length. The end result would be 4 separate fields. Any help is appreciated.

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2014-06-16 : 00:55:24
This link will guide you for splitting one string to multiple columns based on the delimiter...

http://www.everydaysql.com/derive-data-from-one-delimited-column-into-multiple-columns-using-ssis/

--
Chandu
Go to Top of Page
   

- Advertisement -