rmtogether

<div>
Hi, Prabhin MP<br />
<br />
Thanks for your quickly reply<br />
I have admin privilege, I can decide any file locations on both Windows and Linux. <br />
By the way, the communication between Windows and Linux is through the Internet. So I am thinking of SFTP/FTP
</div>


Hi, Prabhin MP

Thanks for your quickly reply
I have admin privilege, I can decide any file locations on both Windows and Linux.
By the way, the communication between Windows and Linux is through the Internet. So I am thinking of SFTP/FTP

<div>
you can use the above command
</div>


<div>
Forget FTP, either use scp like prabhin showed or SFTP (also uses SSH as transport)<br />
<br />
If results are text files be aware that on unix lines end with \n only and in windows \r\n is used.<br />
so you may need a dos2unix before using a file on unix and unix2dos to convert a file ready for use in windows.
</div>


Forget FTP, either use scp like prabhin showed or SFTP (also uses SSH as transport)

If results are text files be aware that on unix lines end with \n only and in windows \r\n is used.
so you may need a dos2unix before using a file on unix and unix2dos to convert a file ready for use in windows.

dfke

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I am thinking to use SSIS to do the following procedure.<br />
<br />
(1) copy many files to Linux machines. then<br />
(2) execute a Linux program (command) to analysis those files. The program will output the result to the local Linux drive<br />
(3) when (2) is done, then pull the result back to Windows machine<br />
<br />
For (1) I am thinking of FTP task (by FTP or SFTP)<br />
<br />
how about the task of (2) and (3) ? &nbsp;Could you please help ... Thanks
</div>
</div>


Dear Experts,

I am thinking to use SSIS to do the following procedure.

(1) copy many files to Linux machines. then
(2) execute a Linux program (command) to analysis those files. The program will output the result to the local Linux drive
(3) when (2) is done, then pull the result back to Windows machine

For (1) I am thinking of FTP task (by FTP or SFTP)

how about the task of (2) and (3) ?  Could you please help ... Thanks

How to execute Linux command from SSIS and files movement between windows &amp; Linux

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

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

Telnet is an application layer protocol used on the Internet or local area networks to provide a bidirectional interactive text-oriented communication facility using a virtual terminal connection. SSH was designed as a replacement for Telnet and for unsecured remote shell protocols. The term telnet is also used to refer to the software that implements the client part of the protocol. SSH provides a secure channel over an unsecured network in a client-server architecture, connecting an SSH client application with an SSH server.

SSH / Telnet Software

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.

How to execute Linux command from SSIS and files movement between windows &amp; Linux

How to execute Linux command from SSIS and files movement between windows & Linux