moving files from linux to windows SQL

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 ?

Thank you.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David FavorLinux/LXD/WordPress/Hosting SavantCommented:
I think you mean moving Linux files to some sort of Windows file system, not an SQL server.

Some recent versions of Microsoft Windows report to have native rsync running. If so, use rsync.

If you have to do this same task repeatedly, best get rsync running on Windows, if it's missing.

If this is a one shot deal, just use whatever you can get to work. Samba or SFTP will work well.

I strongly suggest you move these files over into a directory first + then think long + hard before injecting a bunch of text files into SQL. If you really think you should do this, best to read up on how to represent files inside SQL tables + rows.

Best to read up on this, as you may get yourself in a situation where you have an SQL based set of data which brings your SQL server machine to it's knees when you try accessing this data.

SQL + Filesystems are designed for very different sorts of data.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Marking my answer as a solution, as it describes various ways to accomplish what poster asked.

Poster never posted an update.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.