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 |
vicki
Posting Yak Master
117 Posts |
Posted - 2002-02-22 : 12:49:45
|
What is error mean when use DTS feature in SQL Server 2000 and import the text file:--------------Error Source Microsoft Data Transformation Services Flat File Rowset ProviderError Description: Invalid delimited: text qualifier must be followed by a column delimiter (except the last column),Context: Error calling OpenRowset on the provider |
|
chadmat
The Chadinator
1974 Posts |
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-02-22 : 14:38:46
|
I had this same problem. I had "'s in my fields. Like this"1", "The quick brown fox""2", "The "quick" brown fox"You have to convert the "'s around quick to ' or remove them entirly BEFORE trying to connect to the file with DTS.Michaelmichaelp@televox.com |
|
|
|
|
|