SSIS: row skipped for <none> for the TextQualifier of flat file connection

The following string “_x003C_none_x003E_” may be included in the output file.  If you are receiving this error or other strange flat file results when outputting xml results; it may be due to the values you have set in the flat file connection properties.

 

SSIS_GOTOPROPERTIES

 

1. Right Click on the connection manager icon and inspect the properties of the “Flat File Connection Manager”

The properties you need to review are: 1. HeaderRowDelimiter 2. Text Qualifier Change your settings to match the ones below by selecting 1. {CR} for the header row delimiter 2. Clear the contents of the Text Qualifier SSIS_FLATFILECONNECTIONPROPERTIESSET

 

You should not have values like these images show: SSIS_FLATFILEPROPBAD1

SSIS_FLATFILEPROPBAD2

posted @ 2013-06-05 14:55  Ready!  阅读(514)  评论(0)  编辑  收藏  举报