Datasphere Data Flow did not import all records

[mikehoekstra1]

Hello

We have a task chain that runs a data flow which imports a CSV file from an SFTP site.  It has been running weekly without issues, but today it only imported a subset of the rows.  It did not return an error message. 

Has anyone come across this?  Any way to diagnose what happened? 

Thanks     

[Martin_Kuma]

Hi, CSV :). Was it UTF-8 code page converted? DSP has no code-page option such as InfoPackage in BW.

Does it have empty rows? Check the CSV, or best do not use CSV at all :). From security perspective CSV are a no go, even SFTP is used. 

But for Troubleshooting upload the CSV manually into the table directly in Data Builder \ Table. Just use the upload button in the table. 

Cheers, Martin