Post reply

reading one row less in a job.

  • June 15, 2011 at 9:29 am

    #1339076

    i found the same issue on MSDN, seems 'a file that sometimes contains an extra CRLF at the end of the file' cause the problem.

    but not solution yet, last post at May 24, 2011.

    i really don't want to turn a simple data transfer task to a script task! pls help.

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/510b9dbe-1e76-4d3b-8dad-aaf292a2c0fa

    Did I mention SSIS sucks?

    _______________________________________________________________

  • June 15, 2011 at 9:42 am

    #1339093

    michael wang-201906 (6/15/2011)

    i found the same issue on MSDN, seems 'a file that sometimes contains an extra CRLF at the end of the file' cause the problem.

    The problem is exactly the opposite...the last row is missing a CRLF, not that it has an extra one.

    If you define your rows to contain some columns with a trailing CRLF and the row does not contain a CRLF then what did you expect?

    i really don't want to turn a simple data transfer task to a script task! pls help.

    Ask your data supplier to provide a consistent file or add a CRLF to the file yourself. It's a one-line PowerShell command, i.e. no Script Task necessary.

    Add-Content "C:\file.txt" ""

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply