SSIS脚本组件问题 [英] SSIS Script Component issue

问题描述

你好，

预先感谢您的任何回答/输入.

我目前正在自学在SSIS中工作，这是一个非常不错的工具.
但是，我在使用数据流脚本编写组件时遇到了麻烦.我正在尝试将数据列馈送到转换脚本组件"中，在脚本中运行检查(If语句)，该检查将排除未通过OUTPUT列的未通过检查的任何行.

我可以将数据输入脚本组件，在该组件中运行并完美输出.检查对我来说是问题，即脚本中的实际代码.我需要知道如何跳过未通过检查的任何行.我已经尝试过Row.NextRow()，但是它仍然输出行并且不跳过它.

Hi there,

Thanks in advance for any answers/input.

I am currently teaching myself to work in SSIS, which is a very nice tool.
However, I am having trouble with the Data Flow Scripting Components. I am trying to feed data columns into a Tranformation Script Component, run a check (If statement) in the script that EXCLUDES any rows that dont pass the check from the OUTPUT columns.

I can feed data into the script component, run it through the component and output it perfectly. The check is the propblem for me, the actual code in the script. I need to know how to skip any row that fails the check. I have tried Row.NextRow() but it still outputs the row and doesnt skip it.

Is there a command I am missing?

推荐答案

使用条件拆分定义测试.请遵循:
http://msdn.microsoft.com/en-us/library/ms137886.aspx [ ^ ]


如果您对SSIS有任何疑问，请告诉我，我们将很乐意为您提供帮助.

谢谢，

Kuthuparakkal

use Conditional Split define the test. Follow this:
http://msdn.microsoft.com/en-us/library/ms137886.aspx[^]


Let me know if you have any question with SSIS, I will be glad to help you.

Thanks,

Kuthuparakkal

我认为这将帮助您

http://msdn.microsoft.com/en-us/library/ms345159.aspx [ ^ ]

I think this one will help you

http://msdn.microsoft.com/en-us/library/ms345159.aspx[^]

这篇关于SSIS脚本组件问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！