DTS

Hello,
I want to imports text file having Header and detail sections. Both Header
and Detail sections have different number of fields and different field
separators.
How can i imports such a file using DTS
Thanksread the file twice, filter the header records in one process to a temporary
table, process it again for the details again to a temporary table. process
the temporary tables(s) again to scrub (validate the data) to where ever you
want.
--
Nik Marshall-Blank MCSD/MCDBA
"kailux4" <kailux4@.discussions.microsoft.com> wrote in message
news:CA3AA9AF-5FEE-40D7-84B1-54BE55360E64@.microsoft.com...
> Hello,
> I want to imports text file having Header and detail sections. Both Header
> and Detail sections have different number of fields and different field
> separators.
> How can i imports such a file using DTS
> Thanks