ssmith-nova
24 days agoContributor
FTP File Load Best Practice
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
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