I have a project where I need to move files from a Linux file system to a Microsoft SQL server.
The app that I have resides on a Linux server and allows for older data records to be purged in form of small files. (1kb each)
I need to get these files to the windows server to allow a script (SSIS or other) to read the files and import them into SQL.
This routine will be run nightly, so the thought of a backup or anything else the requires a lot of intervention is not practical.
What's the best way to get this done ?
1. If I have SAMBA loaded on the Linux server, I could easily read the files from a folder share ?
2. I could use [s]FTP to move the files from one system to the other ?
3. Write a script to run on the Linux system to read the files and insert them directly to SQL server via ODBC ?
4. Any other options ?