Posted by jqq on 10/27/56 11:52

W2k3 server, SQL 2005.
@@version = Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Standard Edition on Windows NT 5.2
(Build 3790: Service Pack 1)

I'm trying to set up my first SSIS package to import a flat file to a
database table. The connection manager will not allow a text
qualifier.

My data is comma delimited, with doublequotes around each field. If I
enter " as the text qualifier, then I get the error "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." The data in
Columns view shows as just one column rather than multiple columns.

If I leave the text qualifier as None, then the data in Columns view
shows as just one column again.

I've tried with more than one datafile, including a short sample file
that I set up manually. All files get the same error.

Has anyone else seen this problem?

Thanks much for any assistance!

• Next in forum: Re: Smarter Table build - might split the table
• Prev in forum: Re: Make and save a blob on the fly in stored proc
• Thread view: SQL2005 SSIS - won't allow text delimiters

[Reply to this message]