SSIS中的行采样转换 [英] Row Sampling Transformation in SSIS

问题描述

我的数据流任务中有行采样转换。我希望能够使用属性表达式设置属性行数。

我在数据流任务的范围内将一个名为SampleCount的用户定义变量设置为Int32，默认值为750。

此MSDN http://msdn.microsoft.com/en -us / library / ms183375.aspx [ ^ ] 指定可以使用属性表达式指定此属性的值。



我试图设置SamplingValue属性到@ [user :: SampleCount]，但是我收到一个错误，属性值无效。@ [user :: SampleCount]不是Int32的有效值



所以问题是，为什么我无法访问SamplingValue属性的属性表达式？



谢谢

I have a Row Sampling Transformation in my Data Flow Task. I want to be able to set the property 'Number of rows' using the property expression.
I have set a user defined variable called SampleCount as an Int32 with a default value of 750, in scope of the data flow task.
This MSDN http://msdn.microsoft.com/en-us/library/ms183375.aspx[^] specifies that the value of this property can be specified by using a property expression.

I have tried to set the SamplingValue property to @[user::SampleCount], but I get a error, "Property value is not valid. @[user::SampleCount] is no a valid value for Int32"

So the question is, why am I not able to access the property expression for the SamplingValue property?

Thanks

推荐答案

您无法在行采样组件上执行此操作。

但您可以通过在行采样组件的父DataFlow（来自控制流）上设置表达式来完成此操作。



1.进入套餐的Control Flow标签。

2.选择并右键单击DataFlow包含行采样组件然后选择属性。

3.单击表达式上的省略号（...）

4.从属性下的下拉菜单中选择[行采样]。[ SamplingValue]。注意：如果您重命名了行采样，请查找该名称。

4.单击表达式上的省略号（...），从弹出的窗口中点击Exapand Varaiables签名，将你的变量拖到表达区域。

6.你完成了！

You cannnot do this on Row Sampling component.
But you can do this by setting Expressions on the parent DataFlow(from Control Flow) of Row Sampling component.

1. Go the Control Flow Tab of your Package.
2. Select and Right Click the DataFlow contains your "Row Sampling" component then select Properties.
3. Click on ellipses(...) on Expressions
4. From the drop down under "Property" select "[Row Sampling].[SamplingValue]". Note : if you have renamed your "Row Sampling", please look for that name.
4. Click on ellipses(...) on Expressions, from the window pops up, Exapand Varaiables by clicking + sign, drag your variable to Expression area.
6. You are done!

你好，我已经成功运行了其他包，但是这个包失败了。除此之外没有其他错误。

hello, i have run successfully the other packages but this one failed. There are no other errors aside from this one.

这篇关于SSIS中的行采样转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！