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 |
|
KidSQL
Yak Posting Veteran
88 Posts |
 Posted - 2005-04-29 : 13:37:04
|
| I have a massive text file I am trying to import into SQL Server as a table using the DTS import wizard. I have used this wizard several times and have had no problems. However, with this particular file, I appear to be getting stuck.The text file is several million records and is tab delimited. However, the parsing of the file turns out to be incorrect when I attempt to import as such as all 5 columns of the file are read into a single column. I can try and import the file using fixed width (which is fine by me as there are only 5 columns to deal with) but the 5th column (rightmost) keeps getting cutoff by a fixed, red-line. Does anybody know a workaround solution to this or another way to import this data?The irony is that the file itself is the text output of a SQL Server 2000 query.Thanks in advance. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-29 : 14:00:52
|
| Have you tried bcp?Mike"oh, that monkey is going to pay" |
 |
|
|
KidSQL
Yak Posting Veteran
88 Posts |
Posted - 2005-04-29 : 14:42:43
|
| Actually, I'm trying that now. It's probably going to be best. Thanks. |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-29 : 14:48:37
|
| Good! BCP is so much better than using dts for straight imports. Let us know how your performance is. I think you'll be pleasently surprised.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
Question on file import via DTS