c# - Multi-threading in custom SSIS transformation data flow task -


i have ssis package this: 1. read records flat file source 2. transform calling webservice adds additional response column buffer 3. output input records , response column destination file.

2 custom transformation data flow task wrote, synchronous because outputting input.

i thought default buffersizes , enginethread properties multithreaded , call multiple processinputs @ same time. once ran it, realised called web service 1 @ time.

how can make multi-threaded? i've googled around found myself getting more confused.

thanks in advance

have seen this excellent blog?

quote blog:

sql server integration services (ssis) allows parallel execution in 2 different ways. these controlled 2 properties outlined below.

the first 1 maxconcurrentexecutables, property of package. defines how many tasks (executables) can run simultaneously. defaults -1 translated number of processors plus 2. please note if box has hyperthreading turned on, logical processor rather physically present processor counted.


Comments

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

python - How to remove the Xframe Options header in django? -