Avatar of arthrex
arthrexFlag for Germany asked on

SSIS Text qualifier in Flat File Connection ignored

Hi Experts,

I have a flat file source like this.
"ES";"ITEMGROUP";"299919088880";"Reusable Other";"Standard";""
I've created in SSIS a flat file connection in connection manager with this text qualifier ".
In the preview the data looks fine.
Then I pick the "Bulk Insert Task"-Shape and choose this Data Connection as source. A sql-server table as target.

When I execute  this shape the textqulaifier seems not to be recognized and the quotationmarks are imported to the sql server table.
what am I doing wrong?
Thanks for help.

Microsoft SQL ServerMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
arthrex

8/22/2022 - Mon
rickchild

Bulk insert will use only the field terminator (delimiter) and ignore any quote qualifiers.

You could use a format file which lets you individually specify delimiters per field:

http://msdn.microsoft.com/en-us/library/ms178129.aspx
rickchild

Any reason you are doing a Bulk Insert rather than a standard flat file source import?

Bulk Insert is best suited to data which cannot have invalid delimiters, as it will simply import to the wrong column in the case of bad delimiters.
ASKER
arthrex

thanks a lot for your answers!

I'm very new to SSIS, so thanks for any hint to improve...

with "standard flat file source import" do you mean the "data flow task" shape"?
thats what i tried now. end it was working.

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
rickchild

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
arthrex

thanks a lot!!