sql server dts: Parsing a Text column into table -- sql server dts

Parsing a Text column into table

JAB
11/7/2003 9:10:24 AM

sql server dts:

I need help on this. This is a problem I just inherited from someone else.
There is one table which has a text field/column. This column in the table A
have multiple records stored as one field. example:

rec1: This is a test

rec2: This is a test2

rec3: This is a test3

In this table, all these records are stored as

rec1: This is a test rec2: This is a test2 rec3: This is a test3

with all these stored in one column. What I want to do is to parse this
column into another table call table B where it will be broken into three
separate records. I was thinking of using DTS but how will I be able to
determine where record 1, 2, or 3 starts and ends in the column.

Help please. anyone

I have SQL Server 2k/SP 3/Win 2k sp 4

Re: Parsing a Text column into table

Allan Mitchell
11/7/2003 2:19:56 PM

use the SPLIT Function rather like this

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]