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

Status
Not open for further replies.

tmartin99

MIS
Joined
Sep 14, 2001
Messages
9
Location
US
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?
 

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
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top