SSIS reading LF as terminator when its set as CRLF

by

I have no SSIS experience but as an ETL developer I have faced this many times. So my suggestions might not help you solve the problem but hopefully point you in the right direction

  • If the problem field has text qualifier (single or double quote
    usually) and SSIS supports use it
  • Also if there is an option
    to force SSIS to use different end of record delimiter other than LF (CRLF in this case) I’d use it (hopefully there is no CRLF in the problem field text)
  • If the problem field is not the last field, you can count the number of de-limiters by reading the entire record as a single LF delimited field to
    identify and filter out the problem records (if they are only few)
    and try to stitch them back
  • If possible read the file as single
    record (if SSIS has an option) and replace all LF, provided CR is
    consistent end of record delimiter from the source

More Related Contents:

  1. How do I pass value to a stored procedure parameter in OLE DB Source component?
  2. Why does my ODBC connection fail when running an SSIS load in Visual Studio but not when running the same package using Execute Package Utility
  3. Automate Version number Retrieval from .Dtsx files
  4. Query a database based on result of query from another database
  5. SSIS Source Format Implicit Conversion for Datetime
  6. How to Map Input and Output Columns dynamically in SSIS?
  7. Dynamically assign filename to excel connection string
  8. Importing excel files having variable headers
  9. How to handle this scenario in single SSIS package?
  10. Import Excel spreadsheet columns into SQL Server database
  11. convert Excel Date Serial Number to Regular Date
  12. SSIS Package not wanting to fetch metadata of temporary table
  13. SSIS Excel Import Forcing Incorrect Column Type
  14. How to load an XML file into a database using an SSIS package?
  15. Running an SSIS Package using dtexec
  16. Reverse engineering SSIS package using C#
  17. Temporarily disable all foreign key constraints
  18. Convert from DateTime to INT
  19. What are the differences between Merge Join and Lookup transformations in SSIS?
  20. How to execute SSIS package when a file is arrived at folder
  21. To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher
  22. How to avoid SSIS FTP task from failing when there are no files to download?
  23. Search all tables, all columns for a specific value SQL Server [duplicate]
  24. SQL WHERE.. IN clause multiple columns
  25. SSIS – How to loop through files in folder and get path+file names and finally execute stored Procedure with parameter as Path + Filename
  26. SQL Server: Index columns used in like?
  27. How can I select from list of values in SQL Server
  28. SQL Server tables: what is the difference between @, # and ##?
  29. Sql Server – connect with windows authentication
  30. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express

Leave a Comment