sql server dts: Text file importing probs -- sql server dts

Text file importing probs

Peter Newman
11/21/2003 7:17:16 AM

sql server dts:

Firstly i must give big thanks to Allan for all your
help. I have now hit a brick wall and am getting the same
results no matter what i try

I have an import Text file that contains 10 rows of
header data ( Lenghth 15 bytes ) and N number of
transaction rows containing a single string of data to be
inported into a table using a datapump.

the first thing i am doing is using and activex control
to read the 10 lines of the header into Global veriables.

I then using the data pump read the rest of the file and
import the data into the requited fields. This is where
the trouble starts. I am not getting the correct number
of records imported into the system. If the file has 70
data records i get 71 imported. I have tried all sorts of
things but have still not resolved the problem.

The file Always has 10 header lines read using fso
( File system object ), then anything from 1 line to
5000+ of data lines. If i try and set the text Source
file to skip 1 line , it misses off one of the
transactions.

Re: Text file importing probs

Allan Mitchell
11/21/2003 3:34:33 PM

You want the import to skip 10 lines no ?
Gis a look at your file and dest table structure and I'm sure we can do
something

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]