我可以从表中检索XML中的SSIS配置值吗？(Can I retrieve config values for SSIS from XML in a table?)

 我当前的客户端将其企业应用程序的所有配置信息存储在包含XML的单个表中。 然后他们使用定制的前端来维护配置值。 
 
 我正在为他们使用SSIS编写一个相当直接的导入过程。 我需要使连接字符串和其他一些信息可配置，他们希望我使用他们的表。 看起来像SSIS期待一个文件。 有没有什么办法可以让SSIS从XML流中检索配置值，而不是文件的路径？ 
 
 他们使用的配置表与使用标准向导将SQL Server用作配置源的标准SSIS配置表的结构不匹配。 
 
 感谢您的任何建议！ 

My current client stores all of their configuration information for the enterprise applications in a single table that holds XML. They then use a custom built front end to maintain the configuration values.
 
I'm writing a fairly straight-forward import process for them using SSIS. I need to make the connection strings and some other information configurable and they want me to use their table. It seems like SSIS expects a file though. Is there any way that I can point SSIS to retrieve its configuration values from an XML stream instead of a path to a file?
 
The configuration table that they use does not match the structure of a standard SSIS configuration table that you would get using SQL Server as a configuration source with the standard wizard.
 
Thanks for any advice!

原文：https://stackoverflow.com/questions/1595129