I'm processing a flat file into a database, and it has disparate records...
i.e. start positions for information are not the same for every record.
Now, with Oracle, I could use SQL*Loader to process various load formats...
but does DTS handle various load formats?

I'm using SQL Server 2000. Am I able to do this using DTS? Or what route
should I be using to handle this problem?

Thanks

--
Message posted via http://www.sqlmonster.com

If you have multiple formats of rows in the file then are there ways of
telling what format is what?

If you can then it would be much simpler to parse the file, split to n
files and use those as inputs.

SQL*Loader is extremely flexible but for what you want it would be
difficult to do without a custom grown solution in DTS

Providing I have understood the Q properly.

Allan

"Ray Fox via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Yes, there are actually only two formats for the rows, and the format is
designated by a Record Type number, either 00 or 01.

Now I was thinking that I could just toss the flat file into a table with
two fields... the first being the Type number, the second being a entire
line dump. Then use that table as input for a procedure determining the
transformations I need...

--
Message posted via http://www.sqlmonster.com

That would be one way of doing it yes.


SELECT SUBSTRING(...) FROM TABLE WHERE NumberFirld = '00'


Etc. you get the idea




"Ray Fox via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote