I want to insert a text file with comma seperated fields. De text-field have text qualifiers:
"field1","field2","field3"
I made a Bulk Insert with FMT file. I choose comma seperated with text qualifiers. In the example screen the data looked perfect. After the insert however the text qualifiers where imported into the colimns as well. (The first column contained "field1" instead of field1)

Does anybody have suggestions on how to solve this?

There are examples of doing this on Google. You need to build your own
format file OR if you use the Data Transformation task it will strip them
for you as well.



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"freterink" <freterink (AT) discussions (DOT) microsoft.com> wrote

however the text qualifiers where imported into the colimns as well. (The
first column contained "field1" instead of field1)

I'm using DTS to insert the text file with a Bulk Insert Task. I als used the button Generate to create a FMT file. This FMT file looks like this:

7.0
12
1 SQLCHAR 0 64 "," 1 col1
2 SQLCHAR 0 64 "," 2 col2
3 SQLCHAR 0 64 "," 3 col3
4 SQLCHAR 0 64 "," 4 col4
5 SQLCHAR 0 64 "," 5 col5
6 SQLCHAR 0 64 "," 6 col6
7 SQLCHAR 0 64 "," 7 col7
8 SQLCHAR 0 64 "," 8 col8
9 SQLCHAR 0 64 "," 9 col9
10 SQLCHAR 0 64 "," 10 col10
11 SQLCHAR 0 64 "," 11 col11
12 SQLCHAR 0 64 "\r\n" 12 col25

In the wizard that creates the FMT file I choose Delimited file with the textqualifier ". These qualifiers are however ignored.

"Allan Mitchell" wrote: