Hi

I have an enormous fixed width text file
with 750+ fields and over 4000 characters width (50mb)
It has a hundred character width header and footer.

I am using dts to import into a table, but the header and footer
lines are failing (plus more worryingly line one)

I am not using the bulkinsert task as the format file
is too complex with this many fields so am using
a transform datatask operation.

By deleting the header from a test file I can configure it
to read the header on the live fiel. However it still misses ther footer.

Question is how to access the footer
Any help would be appreciated


jonathan