<div>
Marking my answer as a solution, as it describes various ways to accomplish what poster asked.<br />
<br />
Poster never posted an update.
</div>


Marking my answer as a solution, as it describes various ways to accomplish what poster asked.

Poster never posted an update.

<div>
<div class="content wysiwyg-content">
I have a project where I need to move files from a Linux file system to a Microsoft SQL server.<br />
<br />
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)<br />
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.<br />
<br />
This routine will be run nightly, so the thought of a backup or anything else the requires a lot of intervention is not practical.<br />
<br />
What's the best way to get this done ? &nbsp;<br />
<br />
&nbsp; &nbsp;1. &nbsp; If I have SAMBA loaded on the Linux server, I could easily read the files from a folder share ?<br />
&nbsp; &nbsp;2. &nbsp; I could use [s]FTP to move the files from one system to the other ?<br />
&nbsp; &nbsp;3. &nbsp; Write a script to run on the Linux system to read the files and insert them directly to SQL server via ODBC ?<br />
&nbsp; &nbsp;4. &nbsp; Any other options ?<br />
<br />
Thank you.
</div>
</div>


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.

moving files from linux to windows SQL

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.