Heirarchical data to relational

#1

I need to take a hierarchical text file and import into a
set of relational tables. The first three characters of
each line identify the format of that line. The goal is to
do this with a DTS package that can be executed as new
files are received.

Has anyone got an example of something like this?

Thanks in advance

Have a great 4th

#2

In Books Online lookup

ParallelDataPumpTask Object

--

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

"michael" <mjallen (AT) hchorizons (DOT) com> wrote

Quote:

I need to take a hierarchical text file and import into a
set of relational tables. The first three characters of
each line identify the format of that line. The goal is to
do this with a DTS package that can be executed as new
files are received.

Has anyone got an example of something like this?

Thanks in advance

Have a great 4th

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

Heirarchical data to relational

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

Heirarchical data to relational - 07-03-2003 , 04:26 PM

Re: Heirarchical data to relational - 07-04-2003 , 12:40 AM