Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-14 : 08:35:11
|
| Steve writes "I have a text file that is created by a mainframe and when I load it with DTS everything looks like it worked fine, no error messages, but I am missing records. If I load the text file into Excel I can see all the records. Number of records in text file: 18,072. Number of records imported with DTS: 18,039. Any one have an idea what could be going on?" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-08-14 : 10:00:42
|
| I've encountered this before. What version of SQL Server are you running (incl. service pack)?In the DTS package, do you have logging turned on for the data pump task transform itself (not the package as a whole)? And, do you see anything odd in the mainframe file around the location where the data pump task stops?Jonathan Boott, MCDBA{0} |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-14 : 10:01:19
|
| Are you importing fixed length columns/records?If a record is short then it will miss the next one (using the start to fill in the data?) and not give an error.Not sure about delimitted files but wouldn't rely on an error.You should always have an independent check of the records entered - like a control file with the record count or a sequence on the records.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
henrikop
Constraint Violating Yak Guru
280 Posts |
Posted - 2004-03-17 : 09:13:15
|
| Hiya,I am importing fixed length (main-frame) file. Indeed if a column (or more than one) is missing and thus ending with a carriage return, it misses the next record.How can I solve this (with DTS)? My idea is that when a record is less than x characters (x being the normal row size), than fill it up with spaces. But I haven't got a clue how to do this with DTS, T-SQL. I have to import similar files every day.Henri~~~~It's taken a long time, but I've just about learned how to quit flapping my arms and float. It's good to float. -Al Pacino |
|
|
|
|
|
|
|
|
DTS Import missing records