Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Because we are having the same problems as in http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/e51b775a-8601-491b-8ad4-a71b0f0d59ce we have the following question: That is when inserting from a flat file source we wmiis the last row from the file.

Can you show us where we can find the advanvced column view to set the text qualification to false? Thanks in advance.

share|improve this question

1 Answer 1

That is an option of the "flat file connection" editor. Its on "Advanced->TextQualified". Here is an image of it:

enter image description here

share|improve this answer
    
Ha ha, +1 (soon) for hand-drawn red thingies –  Aaron Bertrand May 22 '13 at 21:42
    
@AaronBertrand Thanks!, I did put so much effort on those red thinguies –  Lamak May 23 '13 at 3:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.