Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS Package Not Importing Last Row in Flat File RE: SSIS Package Not Importing Last Row in Flat File

  • October 10, 2012 at 12:18 am

    #1547468

    HLGEM (6/20/2011)

    We have had the issue of dropping the last record when using SSIS pacakages in the file system. Somehow the SSIS XML file text was changed in copying (do not yet know why) from dev to prod when the text qualifier was set to none.

    The text qualifer XML we used to fix the problem was

    <DTS:Property DTS:Name="TextQualifier"><none></DTS:Property>

    We just opened the SSIS XMl and replaced the text qualifier line that ws in it with the above and saved.

    Even though I'm not sure why this is happening, I pass this on in the hopes it might help your problem.

    The above 'XML code, change to <none>' worked for me, I did not want to go to SP2 path as I am not DBA and shall not install patches on production DBs even though I prefer it should be done.