Skip to main content
S
ssmith-nova
September 9, 2025
Solved

FTP File Load Best Practice

  • September 9, 2025
  • 2 replies
  • 1 view

When I pull a flat file from an SFTP server, I have been parsing that file in VB .net into a Data Table and loading it that way.  

Is this the best way to do this, or is there a way to make the Import read the file from the filesystem once it has been downloaded?  I feel like parsing a csv file using Split() is risky.

Thanks,

Scott

Best answer by ssmith-nova

tschilling​ thank you for the response.  What I am looking for is how best to process the file.  I was overthinking it. I just land the file formatted correctly in the Batch Harvest folder and run it that way.  

Thanks

2 replies

T
tschilling
September 9, 2025

It is possible to use vb.net MemoryStream in the Renci SSH library which is useful for cases where data cannot/should not be stored in OneStream anywhere in the file system.  

S
ssmith-novaAuthorAnswer
September 23, 2025

tschilling​ thank you for the response.  What I am looking for is how best to process the file.  I was overthinking it. I just land the file formatted correctly in the Batch Harvest folder and run it that way.  

Thanks

Terms & ConditionsAccessibility statement