Does anyone know if there is max number of records DTS
will import into a table. I'm getting an error saying
there are too many delimeters in a record but that record
looks fine to me. I'm wondering if this error is just a
generic one and really means something else?? Thanks!

The amount of rows in a table will be strictly dependent on the Destination
provider. SQL Server is limited only by storage.

By record I presume here you mean row in a text file?

Have you looked at it through a HEX editor?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


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

Yes, I looked at the file using ultra edit...looks fine to
me. Has the right amount of delimeters but when I delete
that record it gives the same error at the next record
(row). I even tried deleting the next 200,000 rows, same
error at next record. Really stumped.

1. Have you tried examining the previous row?

2. What is your source? (Text file, Oracle, etc?)

3. What is your destination? (SQL Server, Text file, oracle)

4. Have you tried copying the affending row and prior 10 and subsequent 10
into a separate file and running it?

Scott

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

What you see as spaces may not be what you think they are:

Import the first record or a section of it into Excel and use the
MID function in adjoining cells to return each individual space
in the record. Then, use the CODE function in each cell next
to the MID functions. Code 32 is a space, but so is Code 160.

In the following phrase, the space between SQL and Server is
Code 32, but the one between Server and DTS is Code 160.

SQL Server DTS

Also, what precisely is the delimiter and how often does it repeat
in each record?


Eshoo

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