sql server dts: Data transfer from a single txt file to 3 different tables -- sql server dts

Data transfer from a single txt file to 3 different tables

Hemil
3/21/2005 7:01:17 PM

sql server dts:

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,

Re: Data transfer from a single txt file to 3 different tables

Allan Mitchell
3/22/2005 8:33:04 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.