Hello,

I try to import the data below from a text file using the SQL Server 2005
import wizard with a "Flat File Source" and receive the error "SQL Server
Import and Export Wizard / The preview sample contains embedded text
qualifiers ("). The flat file parser does not support embedding text
qualifiers in data. Parsing columns that contain data with text qualifiers
will fail at run time."
With SQL Server 2000 this was no problem. The files I want to import are
about 100MB in size. Any workaround?

Sample data:
1 inch,"2""","3 inches","4, 5, and 6""",7 inches,"8"", 9"",""10""""",11
inches

Kind regards,

Frank

Hello Frank,

It seems to be a known bug in the old version of Yukon. It is supposed to
be fixed after 1121. What is version of your server?

Also, for SQL 2005 issue, you may access the following website:

http://www.microsoft.com/technet/com...erver/sql.mspx

Then click "SQL Server 2005 Forums on MSDN"

Thanks for cooperation.


Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.


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

Hello Peter,

select @@version returns: Microsoft SQL Server 2005 - 9.00.1314.06 (X64)
Sep 2 2005 21:10:23 Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

It's the most recent CTP.

Regards,

Frank

Hello Frank,

Thank you for your feedback on this. Based on my test, though the warning
error message appear, we still could import the data, the package could run
successfully.

Again, thank you for reporting this. Please rest assured this feedback has
been routed to the proper channel. Have a great day!

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.


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

Hello Peter,

in how many Colums with what values was the string splittet in your test? I
could not import it.

Regards,

Frank

Hello Frank,

There are 9 columns. I used the following method to import.

1. Open import/export wizard
2. Select "flat file source", and select the txt file I want to import
3. On General tab, set "text qualifier" to ".
4. When I move to Columns tab, I recieved the error message you want.
5. I select Row delimiter in "CR/LF" and column delimiter to {,}
6. Follow the wizard to finish it. 1 row was transfered

I exported the result into a csv file and it is the result:

1 inch,2"",3 inches,4, 5, and 6"",7 inches,8", 9"","10"""",11

Hope this is useful for you.

Thanks & Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:

BCPS:
https://partner.microsoft.com/US/tec...rview/40010469

Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...rnational.aspx.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
<#Jf2YcI1FHA.2312 (AT) TK2MSFTNGP14 (DOT) phx.gbl>
<Tmdk3#U1FHA.2244 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>

Hello Peter,

your export data (1 inch,2"",3 inches,4, 5, and 6"",7 inches,8",
9"","10"""",11) is not as it should be. BTW: This data would be splittet
into 11 not 9 colums. Also the " inches" at the end are missing. Your
experiences confirm the inability to handle embedded qualifiers of the flat
file provider.

My data (1 inch,"2""","3 inches","4, 5, and 6""",7 inches,"8"",
9"",""10""""",11 inches) should be splitted into 7 colums because I use
embedded textqualifiers ("):
1 inch
2"
3 inches
4, 5, and 6"
7 inches
8", 9","10""
11 inches


Regards,

Frank

Hello Frank,

Thank you again for your feedback to clarify the sitaution. I have reported
this to product group. If there is any update on this, we will let you
know. Have a great day!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
<#Jf2YcI1FHA.2312 (AT) TK2MSFTNGP14 (DOT) phx.gbl>
<Tmdk3#U1FHA.2244 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>
<#07fTeW1FHA.3892 (AT) TK2MSFTNGP12 (DOT) phx.gbl>
<1iI97WG2FHA.2336 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>

Tank you very much in advance Peter,

as we speak of the flat file provider it would also be great to allow souce
data to contain Chr(0) characters. At this time most text import filters
(e.g. ISAM/ADO) truncate such data.
I would for example be able to import the Microsoft Glossaries
ftp://ftp.microsoft.com/developr/msdn/newup/glossary/ with SSIS
unproblematically.

Kind regards,

Frank

Hello Frank,

Thank you for your great input. I have forwarded your suggestions to the
proper channel. I think it is not easy to truncate 0x0 because it is
usually indicates a end of a string.

Also, you may want to submit this to mswish channel:

- Click Microsoft.com Guide in the upper-right corner of the page and then
click Contact Us . Click the link in the Product Suggestion section of the
page that appears.

- Visit the following Microsoft Product Feedback Web site
http://register.microsoft.com/mswish/suggestion.asp
and then complete and submit the form.

E-mail - To send comments or suggestions via e-mail, use the following
Microsoft Wish Program e-mail address, mswish (AT) microsoft (DOT) com.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
<#Jf2YcI1FHA.2312 (AT) TK2MSFTNGP14 (DOT) phx.gbl>
<Tmdk3#U1FHA.2244 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>
<#07fTeW1FHA.3892 (AT) TK2MSFTNGP12 (DOT) phx.gbl>
<1iI97WG2FHA.2336 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>
<uINNXIW2FHA.4004 (AT) TK2MSFTNGP09 (DOT) phx.gbl>
<4uRkgVt2FHA.2904 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>