开发者

How to create an Asynchronous Script Component in SSIS?

I might be blind, but I don't see how to CREATE the script component. I'm not asking why do an asynchronous, how 开发者_运维技巧to work with it, etc. I just want to know how to add it to my package, or how to transform an already existing component into an asynchronous one!

I'm using VS2008 with MSSQL 2008 R2.


I found how :

  1. Go in the Script Transformation Editor
  2. Select "Inputs and Outputs" from the leftmost part of the screen.
  3. Select your Output.
  4. Set "SynchronousInputID" to "None".

Thanks to this site.


Creating an Asynchronous Transformation with the Script Component

First bullet point under "Configuring Inputs, Outputs, and Output Columns"

Set the SynchronousInputID property of each output to zero to indicate that the output does not simply pass through data from an upstream component or transform it in place in the existing rows and columns. It is this setting that makes the outputs asynchronous to the input.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜