SSIS DTS Package Flatfiles with _x003C_none_x003E_

If you see “_x003C_none_x003E_” in the output file (probably a CSV), it is because the value of the text qualifier is set to “_x003C_none_x003E_”.  It is a bug.

You can fix it by opening the package with notepad and remove “_x003C_none_x003E_” from TextQualifier.

Change from

<DTS:Property DTS:Name=”TextQualifier”>_x003C_none_x003E_</DTS:Property>

To

<DTS:Property DTS:Name=”TextQualifier”></DTS:Property>

You can verify by checking it with Visual Studio:

image

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