Home Forums Data Warehousing Integration Services [Flat File Source [1]] Warning: There is a partial row at the end of the file. using 2008 R2 RE: [Flat File Source [1]] Warning: There is a partial row at the end of the file. using 2008 R2

  • May 3, 2015 at 8:02 am

    #1795239

    sorry, I don't know C#...

    There should be no need to clean / replace the thorn character, just configure it as a delimiter for the source.

    FF Source doesn't offer thorn as a possible alternate to comma (in the header row delimiter drop down), so I use Derived Column to replace the thorn character with | in this way:

    REPLACE([creative_idþgroup_idþdateþimpressionsþclicksþpublisher_costþavg_posþavg_cpcþconversion_type_idþconversionsþrevenueþlast_modified],"þ","|")

    ...and it works in al 43 flat file imports except for this one. How would you do this?

    --Quote me