Hi

I have quite a strange DTS problem. I wrote a script to load data from
a Excel spreadsheet into a Access database. If I run the script
(doesn't matter if I run it from Enterprise Manager or with vb code),
it just skips some rows from the source file.
The rows in the spreadsheets are always grouped, means I have about 10
rows, some empty rows, another 10 rows, empty rows... (Cannot change
this, it's a data extract of an existing system)
One of this "blocks" of 10 rows is just skipped. The block before and
the block after are loaded correctly, also all the other blocks in the
spreadsheet. I compared the cell format and they are the same. I don't
have any conditions in the DTS which could exclude this rows (just
conditions to exclude the empty rows).

Does anybody know a problem like this?

Michael

Couple things: are you positive there aren't any weird symbols in the
"blank area" before the block that is skipped (check in hex edit mode
or whatever) Does running your package against different datasets
cause it to skip in the same spot?

As far as "...cannot change this...existing system" you can copy the
source file and preprocess it (stripping blank lines for example) using
an ActiveX task or a execute process task for example. The same data
will still get to the destination and you gain some flexibility at the
cost of additional processing time. Just a thought.

Thank you for this input.

I "solved" the problem for the moment by extracting these particular
rows to a single spreadsheet and import it from there: it worked... I
can do this right know as we still are in a pilot stage. I will have to
really fix this problem later most likely, i'll try your tipps then!