I just received a table migrated from the ServiceCenter.
There is a long char column, which is in fact a series of
column in ServiceCenter data.

How can I parse it into additional fields in SQL Server; or
is there any instruction/guideline, from which a utility
tool, e.g. Crystal Report, can parse the extracted data
while the long char column is migrating to SQL Server?

Can I do this task in DTS?

Thanks in advance.

Jeffrey

In article <00a101c3a485$cbd18f20$a301280a (AT) phx (DOT) gbl>, Jeffrey
<jwang (AT) dot (DOT) state.tx.us> writes
If you have delimiters or a fixed width format the simplest way would be
just use T-SQL, and write a
INSERT NewTable (COl1A, ...)
SELECT LEFT(COl1, 1)....

You could also use a DTS package. Use the DataPump task to transfer
between the old and new table, and use an ActiveX Script Transform on
the column in question. You can then split the column or use associated
string manipulation commands in VBS to split the data and assign it the
multiple destination columns.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Where can I find the article <00a101c3a485$cbd18f20
$a301280a (AT) phx (DOT) gbl>? A web site at www.phx.gbl or send a
email?

Thanks,
Jeffrey

In article <09d201c3a4a3$a6055e20$a001280a (AT) phx (DOT) gbl>, Jeffrey
<jwang (AT) dot (DOT) state.tx.us> writes
What does that mean? May be you cannot see the message so I'll try
again, but maybe you won't see this either. Maybe nobody else is really
out there...


If you have delimiters or a fixed width format the simplest way would be
just use T-SQL, and write a
INSERT NewTable (COl1A, ...)
SELECT LEFT(COl1, 1)....

You could also use a DTS package. Use the DataPump task to transfer
between the old and new table, and use an ActiveX Script Transform on
the column in question. You can then split the column or use associated
string manipulation commands in VBS to split the data and assign it the
multiple destination columns.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I can read your reply message, "If you have delimiters
or ........." But I can not understand "article
<00a101c3a485$cbd18f20$a301280a (AT) phx (DOT) gbl>, Jeffrey" at the
begining of your email. I thought you want me to read an
article in @phx.gbl.

Thanks,
Jeffrey

In article <03b901c3a4b0$e9025770$a401280a (AT) phx (DOT) gbl>, Jeffrey
<jwang (AT) dot (DOT) state.tx.us> writes
The beginning, e.g.

In article <03b901c3a4b0$e9025770$a401280a (AT) phx (DOT) gbl>, Jeffrey
<jwang (AT) dot (DOT) state.tx.us> writes

is just my news reader's default reply style. Nothing to worry about.

Cheers

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org