开发者

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

开发者 https://www.devze.com 2023-01-03 14:22 出处:网络
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 ab

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 file开发者_StackOverflows from another Server: during execution, all files must be located on the Job Server machine that executes the job.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消