How to Export CSV File with Double Quotes as Text Qualifier with SSIS


In the Flat File Connection Manager Editor (double click on your flat file manager name to launch the editor),
you can define a Text Qualifier, so you can choose double quote ( ” ) as TextQualifier on the General page (General tab on the right).
You can choose your column delimiter from the Column tab page if you want something other than Comma{,}.
Normally, I prefer to use tab {t} ot Vertical bar {|} as my top choices.

Not:
After you select a text qualifier, you cannot re-select the None option. Type None to de-select the text qualifier.

You can find detail information from MSDN links:

http://msdn.microsoft.com/en-us/library/ms187017.aspx
http://msdn.microsoft.com/en-us/library/ms180239.aspx

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s