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: 318

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

Related posts about sql-server

Related posts about sql-server-2008