Hello Friends,

I have a data file containing Purchase Orders coming in
from a proprietary ERP system. The file contents can be
divided into 3 parts: Header, Lines and Notes. These 3
parts need to go into three different SQL Server Tables
for my custom application.

Is it possible in DTS to channel data from a single source
text file to three different destination tables ? I had a
look around but could not find anything to achieve this.
Are there any other alternatives I could use if this is
not possible by DTS ?

Thanks & Regards,
Hemil.

Not really. The thing is DTS likes its metadata and it likes it to be
consistent.

You could read the whole line as a string and then parse the line but
that would probably be costly.

I would look to either get the source to give you 3 file or I would
split the file into 3 yourself.


Allan

"Hemil" <anonymous (AT) discussions (DOT) microsoft.com> wrote