更改 SSIS 中缓慢变化的维度转换的属性
我在更改 SSIS 2005 中 SCD 转换的属性时遇到问题。
我可以在第一次编辑转换及其工作时定义所有属性和映射。
但是当我再次打开组件的属性编辑器时，它忘记了所有输入的配置，例如表列的映射和列的设置。
我什至在生成的 XML 中搜索了设置，但没有找到任何有意义的内容。
SSIS 已明确将组件配置存储在某处，因为在我打开编辑器之前它工作正常。
我已经在网上搜索过，但还没有运气。 有谁知道设置分别存储在哪里如何强制组件编辑器/助手不要忘记我的所有设置？
I have a problem with changing the properties of the SCD transformation in SSIS 2005.
I can define all the properies and mappings the first time i edit the transformation and its working.
But when i open the property editor of the component again, it has forgotten all the entered configuration like the mappings of the table columns and the settings of the columns.
I even have searched in the generated XML for the settings but have not found anything meaningful.
SSIS has definitly stored the components configuration somewhere because its working fine until i open the editor.
I have searched the web but with no luck yet.
Does anybody know where the settings are stored respectively how to force the components editor/assistant to not forget all my settings?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
SSIS 中的 SCD WIZARD 不是编辑器，而是向导。这是它最大的缺点之一。它不记得任何配置。每次您使用该向导时，它都会从头开始并重新创建它用来执行缓慢变化的维度的所有对象。如果您想要一个能够记住两次使用之间的设置的 SCD 组件，您可能应该使用 Todd McDermid 的优秀工具：DimensionMerge SCD 组件
The SCD WIZARD in SSIS is not an editor, it is a wizard. That is one of its biggest drawbacks. It doesn't remember any configuration. Every time you use the wizard, it starts again from the beginning and recreates all of the object it uses to do the slowly changing dimension. If you want an SCD component that will remember the setting between uses, you should probably use the excellent tool by Todd McDermid: DimensionMerge SCD Component
我也遇到了这个问题，近两周来一直在网上寻找解决方案。我终于找到了解决办法。通过 SCD 组件的 xml 定义，具体为：
重要的是，标签的内容
dwd:value与标签本身位于同一行。如果存在换行符，SCD 向导将不会加载您的设置。我知道，它是有线的。此外，具有dqd:key的值应由 制表符 分隔。最重要的是dwd:value的内容在同一行开始。希望这可以帮助别人。I have had this problem too for almost 2 weeks crawling through the net to find the solution.I finally found a way out. With the xml definition of the SCD component, specifically :
It is IMPORTANT that the the content of the tag
dwd:valueis on same line as the tag itself. If there is a line break, the SCD wizard will not load your settings. I know, its wired. Also the values with thedqd:keyshould be seperated by a tab. The most important is that the content of thedwd:valuestart on same line. Hope this helps someone out.