Convert Delimited Column to Table

#1

I am converting data from a multi-dimensional database which means that many
of the columns are in-effect sub-tables that have delimited values. As a
result for each of these columns I need to create/insert/update a table.
Does DTS have a function that will do this?

Thanks

#2

Unfortunately no.

You would need to roll your own solution. I would love to hear more about this product and your requirements though.

The nearest typ of thing i can easily think of is this article

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"Mike Harbinger" <MikeH (AT) Cybervillage (DOT) net> wrote

Quote:

I am converting data from a multi-dimensional database which means that many of the columns are in-effect sub-tables that have
delimited values. As a result for each of these columns I need to create/insert/update a table. Does DTS have a function that will
do this?

Thanks

#3

Unfortunately no.

You would need to roll your own solution. I would love to hear more about this product and your requirements though.

The nearest typ of thing i can easily think of is this article

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"Mike Harbinger" <MikeH (AT) Cybervillage (DOT) net> wrote

Quote:

I am converting data from a multi-dimensional database which means that many of the columns are in-effect sub-tables that have
delimited values. As a result for each of these columns I need to create/insert/update a table. Does DTS have a function that will
do this?

Thanks

#4

Allan

Thanks for your response. The DB product has been around for many years and
is called Advanced Revelation. It's architecture is based on the Pick
operating system. Unfortunatley I am new to SQL coding so not sure where to
start in terms of a completely hand-rolled solution.

Taking this from a different approach, if you had an ASCII file that
consisted of a single comma delimited row vs a file that had multiple rows,
how would parse the string values into SQL table rows?

Thanks again!

#5

I would use something like the article I posted to you.

Are the rows to go into the same DB and table? Different?

Lookups spring to mind

Using the current version of SQL Server DTS you will not have a performant solution I can think of immediately. In the next release
thoough it is quite different.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

"Mike Harbinger" <MikeH (AT) Cybervillage (DOT) net> wrote

Quote:

Allan

Thanks for your response. The DB product has been around for many years and is called Advanced Revelation. It's architecture is
based on the Pick operating system. Unfortunatley I am new to SQL coding so not sure where to start in terms of a completely
hand-rolled solution.

Taking this from a different approach, if you had an ASCII file that consisted of a single comma delimited row vs a file that had
multiple rows, how would parse the string values into SQL table rows?

Thanks again!

#6

Alan

Quote:

Are the rows to go into the same DB and table? Different?

Rows are coming from an exported ASCII file and into a new, SQL table as
follows:

ASCII export file:
-------------------
Row1
Row2
Row3Val1, Row3Val2,Row3Val3....
Row4

New SQL table:
------------------
Row3Val1
Row3Val2
Row3Val3....

Will the new version of DTS be released as part of the next major SQL Server
upgrade or separatly and do you have any ETA?

Thanks again

#7

SQL Server DTS is to be reknown as SQL Server Integration Services. It is
scheduled to be released middle next year ish

www.SQLIS.com

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"Mike Harbinger" <MikeH (AT) Cybervillage (DOT) net> wrote

Quote:

Alan

Are the rows to go into the same DB and table? Different?

Rows are coming from an exported ASCII file and into a new, SQL table as
follows:

ASCII export file:
-------------------
Row1
Row2
Row3Val1, Row3Val2,Row3Val3....
Row4

New SQL table:
------------------
Row3Val1
Row3Val2
Row3Val3....

Will the new version of DTS be released as part of the next major SQL
Server upgrade or separatly and do you have any ETA?

Thanks again

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Convert Delimited Column to Table

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Convert Delimited Column to Table - 11-19-2004 , 08:41 AM

Re: Convert Delimited Column to Table - 11-20-2004 , 01:26 AM

Re: Convert Delimited Column to Table - 11-20-2004 , 01:51 AM

Re: Convert Delimited Column to Table - 11-21-2004 , 02:30 PM

Re: Convert Delimited Column to Table - 11-21-2004 , 02:55 PM

Re: Convert Delimited Column to Table - 12-02-2004 , 09:07 AM

Re: Convert Delimited Column to Table - 12-02-2004 , 01:03 PM