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 |
|
www051906
Starting Member
7 Posts |
 Posted - 2005-11-14 : 14:13:28
|
I've setup a DTS package that imports a source text file into a sql table. The source file contains 5 records. The DTS package only imports the first 3. As a matter of fact, in DTS's "Connection Properties" for the source file, "Text File Properties", the Preview pane only shows the first three records. Now, I am aware that the 4th record in the source file is quite large. Could DTS be ignoring this last record for some size reasons? What size limits are placed in incoming data? on text files?  |
|
|
www051906
Starting Member
7 Posts |
Posted - 2005-11-14 : 14:18:26
|
| Another thing to note on the above... I give the package and import file to another user of Enterprise Manager 8.0 (same version as me) and SQL 2000 (same version as me) and she sees all 5 records, and imports them. What's the deal? |
 |
|
|
|
|
|
DTS - Record/File Size Limits