We have the same issue with two of our packages developed in BIDS 2008 and deployed on SQL Server 2008 R2.

We do not have the issue in our DEV environment which is at version:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1790.0 (X64) Apr 22 2011 11:55:34 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)

PROD does not have the Cumulative 4 Pack on yet and that is where we see the issue. We will be putting on the cu soon, but it is not a known issue fixed in this KB.

PROD version: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)

The import files are .csv and there are no apparent anomalies in the column delimiters or designated row identifier (even for the last row). When running one package as part of a job from the SQL Agent, the last record is skipped every time. Text qualifier is set to none. We are baffled.

Anyone with a resolution or work around?

Thanks