提取数据客户端
我需要能够从客户端计算机上的数据源提取和转换数据，并通过 Web 服务调用将其发送到我们的数据存储中。我希望能够利用 SSIS，但 Sql Server 许可协议阻止我在客户端计算机上安装集成服务。我可以只提供集成服务程序集的客户端副本以供我的应用程序引用吗？除了从头开始构建自定义解决方案之外，是否有人对如何最好地实施此问题的解决方案有任何想法？理想情况下，解决方案应包括利用现有的 ETL 工具？
感谢您的建议。
I need to be able to extract and transform data from a data source on a client machine and ship it off via a web service call to be loaded into our data store. I would love to be able leverage SSIS but the Sql Server licensing agreement is preventing me from installing Integration Services on a client machine. Can I just provide the client copies of the Integration Services' assemblies to be referenced by my app? Does anyone have any ideas on how to best implement a solution to this problem apart from building a custom solution from the ground up? Ideally the solution would include leveraging an existing ETL tool?
Thanks for your suggestions.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果您要为客户提供围绕其数据的服务，您应该制定一个他们交付数据所需的标准，并在考虑如何使用 SSIS 之前协商该文件的交付方法。由于从评论来看，您的数据似乎位于客户端远程位置的计算机上，因此我见过的最常见的方法是让客户端 SecureFTP 将文件放入您的网络中进行处理，或者在您端进行一项工作来获取使用 SecureFTP 文件。一旦您的网络上有了该文件，编写 SSIS 来处理它就很简单了。
If you are providing your client with a service around their data, you should develop a standard that they need to deliver their data in, and negotiate a delivery method for that file well before you ever consider what to do with SSIS. Since from comments it appears that your data is on a machine in a client's remote location, the most common method I have seen is either having the client SecureFTP a file into your network for processing, or to have a job on your end that gets the file using SecureFTP. Once you have the file on your network, writing the SSIS to process it is trivial.
如果服务器可以连接到客户端计算机，那么您只需在服务器上运行 SSIS 包即可。您要移动什么类型的数据？如果它是平面文件，您可以将其通过 FTP 传输到服务器。
另一种方法是使用 BCP。我不太喜欢这种方法（SSIS 更快、更健壮等等），但它可以在紧要关头发挥作用。
http://msdn.microsoft.com/en-us/library/ms162802。 ASPX
If the server can reach out to the client machine, then you can just run the SSIS package on the server. What kind of data are you moving? If it's a flat file, you could FTP it to the server.
Another way to go about this is to use BCP. I'm not a big fan of this approach (SSIS is much faster, more robust, etc), but it can work in a pinch.
http://msdn.microsoft.com/en-us/library/ms162802.aspx