SSIS 条件拆分，但想要检查模式 [英] SSIS conditional split, but want to check a pattern

问题描述

请看下面的流程图.

我怎样才能真正实现它.它在 SSIS 表达式中尝试了各种方法.

How can i really achieve it. It tried various things in the SSIS Expression.

推荐答案

如果您想使用正则表达式，那么您可以使用脚本组件来填充(新)列，然后使用条件拆分来过滤该列.或者您可以将好"和坏"行重定向到脚本组件本身的输出.这是一个例子.它将错误的电子邮件地址重定向到其他输出:http://microsoft-ssis.blogspot.com/2011/03/regular-expressions-in-ssis.html

If you want to use regular expressions then you could use a Script Component to fill a (new) column and then use a Conditional Split to filter on that column. Or you could redirect the 'good' and 'bad' rows to their own output within the Script Component itself. Here is an example of that. It redirects bad email addresses to an other output: http://microsoft-ssis.blogspot.com/2011/03/regular-expressions-in-ssis.html

这篇关于SSIS 条件拆分，但想要检查模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！