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
Post a Comment