I am importing a 13 field text file into SQL Server using DTS and the first column is a 9 digit text field and the last field is a 9 digit text field. The first field will always have data, but the last field can contain "null" values, but when I import the file, if the last field is "null" then the import replaces the values in the last field with the first 9 characters from the next record. What is going on?
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!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
importing text file into new SQL server table
- Thread starter tmartin99
- Start date
tlbroadbent
MIS
Edit the Package and open the connection to the text file. Click on the properties button. Chack the row delimiter and make sure it is correct. Also check the type of file, Delimited or Fixed Length. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
- Locked
- Question
