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?
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)
Sample data:
1 inch,"2""","3 inches","4, 5, and 6""",7 inches,"8"", 9"",""10""""",11
inches
Kind regards,
Frank
Hi Frank...
Found your post here:
http://www.eggheadcafe.com/forumarchives/sqlserverdts/oct2005/post24522404.asp
Any progress in the concerning topic?
|||Check this:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7952c866-807b-4715-80ba-498e0a16ab18&DisplayLang=ensql
No comments:
Post a Comment