Skipping Items in Foreach loop container
来源:互联网 发布:宁夏网络教育 编辑:程序博客网 时间:2024/05/29 08:31
业务背景:
在使用Foreach loop container 遍历文件夹的时候,有时候需要做一些排除条件,对一些特定的文件夹或者文件不作处理。
然而该控件本身并没有提供这样的过滤选项
解决方法:
1.在data flow之前放一个空的对象,可以是script task,也可以是sequence container.
2.修改Precedence Constraint,在自定义expression当中设置过滤条件。以文件路径名当中的关键字作为筛选项。
比如过滤掉backup文件夹,就写FINDSTRING( @[User::strFileLocation], “//backup//” ,1) == 0
当然,为了便于日后管理维护,永远推荐使用Variables而不是硬编码.
3.大功告成
0 0
- Skipping Items in Foreach loop container
- SSIS 组件使用 Foreach Loop Container and Execute SQL Task
- Foreach Loop
- Don't know how to iterate over supplied "items" in <forEach>
- Don't know how to iterate over supplied "items" in <forEach>问题的解决方法
- Don't know how to iterate over supplied "items" in <forEach>
- Don't know how to iterate over supplied "items" in <forEach>
- Don't know how to iterate over supplied "items" in <forEach>
- 关于: Don't know how to iterate over supplied "items" in <forEach>
- 异常问题: Don't know how to iterate over supplied "items" in <forEach>
- foreach VS for loop
- SSIS – For Loop Container
- How to Iterate over Array in Java 1.5 using foreach loop Example
- 关于出现Don't know how to iterate over supplied "items" in &amp;lt;forEach&amp;gt;异常
- javax.servlet.jsp.JspTagException: Don't know how to iterate over supplied "items" in <forEach>
- javax.servlet.jsp.JspTagException: Don't know how to iterate over supplied "items" in <forEach>
- Don't know how to iterate over supplied "items" in &lt;forEach&gt;解决办法
- 'for' loop replaceable with 'foreach'
- poj 3159 差分约束 + SPFA + 栈
- Swift运行时简介
- 最新PHP 经常用到的数据过滤的方法
- 快照复制使用
- jeecms导入myeclipse,启动tomcat报错Exception in thread "Task-Thread-for-com.mchange.v2.async.ThreadPerTaskA
- Skipping Items in Foreach loop container
- mybatis用集合多层封装查询结果
- grid添加滚动条之viewConfig——autoFill、forceFit属性初了解
- 0-1背包把数组压缩到一维后为何要倒序循环
- 内核与文件系统
- hdoj 1102 Constructing Roads (prim)
- android studio安装遇见的问题
- HttpClient 使用get方式发送数据到服务器并下载服务器文件
- com.google.gson.stream.MalformedJsonException的解决办法