SSIS - flat file import incomplete

• senger-598100

  Valued Member

  Points: 54

  More actions

  January 29, 2008 at 5:26 am

  #120227

  Hi, when I run my data flow to import flatfile data into a new table in the sql-server, everything seems to be fine, no error message or anything. But when I checked the imported data, I saw that only part of the records was imported (out of approx. 700 recs 385 records). I marked the records which were not imported, but I could not find any reason, there were nulls in both imported and not imported cells, length of the cells is not a problem, I don't have a column on the sql-table, where nulls are not permitted. Does anyone know the problem and how to solve it?

  Thanks

  Susanne

• Todd Engen

  SSCrazy Eights

  Points: 9869

  More actions

  January 29, 2008 at 6:26 am

  #772814

  Can you post a few of the lines from the flat file that do and don't cause errors?

  Also, for the Flat File source what are the DataType and ColumnWidth properties for each output column in the Flat File connection manager?

• //Ravi

  SSCrazy

  Points: 2612

  More actions

  January 29, 2008 at 10:08 am

  #772966

  In the Flat File Souce Editor, do you have Error and Truncation set to "Fail Component" or "Ignore Failure"?

  Ravi.

  ------------
  🙂