Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trailer Record being ignored

Status
Not open for further replies.
TomKane

TomKane

Programmer
Jul 24, 2001
1,018
AU
Hello,

We're having an issue with the import of a traier record and would be grateful for any advice that you might have.

What is happening is that we have a text file with a trailer record - we have a DTS task that imports the contents of the file to a SQL Server table. All the detail records import OK but the trailer record seems to be getting ignored. All the detail records are 460 characters in length wheras the trailer record is 32 characters as below:

000000003464128/07/05FLR016BR00

Has anyone seen anything like this before? Is it something that can be controled in DTS?

Thanks,
Tom
 
Status
Not open for further replies.

Similar threads

ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
178
drlex
drlex
mody82
  • Locked
  • Question
Trigger for inserting record into another table
Replies
2
Views
48
mody82
mody82
mtepfer
  • Locked
  • Question
Selecting Top Record 1
Replies
2
Views
43
mtepfer
mtepfer
ElEye
  • Locked
  • Question
CSV import skips records
Replies
0
Views
60
ElEye
ElEye
aswolff
  • Locked
  • Question
How to add new dimension record 1
Replies
1
Views
50
RiverGuy
RiverGuy

Part and Inventory Search

Sponsor

Back
Top