How to create an Asynchronous Script Component in SSIS?

Question

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.

Tipx · Accepted Answer · 2011-09-21 16:39:22Z

4

I found how :

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

Thanks to this site.

answered Sep 21, 2011 at 16:39

Tipx

7,5354 gold badges40 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

billinkc · Accepted Answer · 2011-09-21 16:43:36Z

1

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.

edited Sep 21, 2011 at 16:43

answered Sep 21, 2011 at 15:10

billinkc

61.4k10 gold badges110 silver badges169 bronze badges

3 Comments

Tipx Over a year ago

I already read that, but I don't see the "Click here to set it to asynchronous" part.

billinkc Over a year ago

Yup, you should have your eyes examined ;)

SalgoMato Over a year ago

Docs would be clearer if they say "set the property to None" instead of zero.

Collectives™ on Stack Overflow

How to create an Asynchronous Script Component in SSIS?

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related