Hi,
when imported fixed length text file to database the result is not
completed, not all rows in the text file were imported by DTS.
What happend with this....

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

How many rows were missed?
Just the last?

Could it be the file is not terminated correctly?



"Abdul Darnis via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote in
message news:forum (AT) SQLMonster (DOT) com:

After checking the data, i found the only odd rows that imported, while
even rows is not imported.

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

Heck the terminators on each even line.

"Abdul Darnis via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote in
message news:forum (AT) SQLMonster (DOT) com:

Perhaps in the first instance you should check the terminators, then move on
to hecking.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

OK Allan/Darren
Thanks for your help...after check again to the data, i found that the last
column in my data was not always appear (sometime blank). I swap the column
order and then it's all works =)

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

<grin>

For "heck" read "check"

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote in
message news:darren.green (AT) reply-to-newsgroup-sqldts (DOT) com: