sql-serversql-server-2008ssisbusiness-objects

Is SSIS able to query flat files from another Windows Server?

I'm 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 Windows 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.

Solution

  • Yes, you can access text files on another server using SSIS by using a fileshare and accessing the files using the share name i.e. \\ServerB\MySSISFiles\.

    You need to make sure that the account the SSIS is running under has access to the file share.