Is SSIS able to query flat files from another Windows Server?
Posted
by atricapilla
on Stack Overflow
See other posts from Stack Overflow
or by atricapilla
Published on 2010-06-17T05:06:23Z
Indexed on
2010/06/17
5:13 UTC
Read the original article
Hit count: 321
I pretty new SQL Server Integration Server (SSIS) user. Is SSIS able to query data from text files located in another Windows Server? I mean that when SSIS is installed on Windwos Server A, is SSIS able to query data from e.g. one folder containing text files in Windows Server B (under same domain)? I have used only SAP BO Data Integrator ETL tool and it cannot query flat files from another Server: during execution, all files must be located on the Job Server machine that executes the job.
© Stack Overflow or respective owner