I have a fixed length text file in which 1 rec has many fields that stretch to a column length of about 10,000. The DTS wizard bugs out at about the 3700 position number and it doesn't allow me to designate a field beyond that; nor can I remove one of the automated field designators. Also, I noticed that the terminator is on position 8000 which is way short of where I need it to be. Any suggestions? Thx
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing a text file with a large column length...help
- Thread starter rmchung
- Start date
- Thread starter
- #3
Okay, I was able to get it into a staging table using bulk insert and all the data actually placed through into a text datatype. Now I think my problem is parsing it out into the 187 fields I need it to be in. I'm not sure I can use such a large SQL statement to do this. Any thoughts on this? Thx
- Status
Similar threads
- Locked
- Question