I created the package to download 4 ftp files at once.
I set the MaxConcurrentExecutables for the SSIS package to 4. So in BIDS in downloads 4 files at the same time.
However, when I started the job I noticed that only 3 files were downloaded at the time (looking at temp files in download directory)
Solution:
Sure enough after digging around for awhile - in Step properties for SSIS package - there is execution tab - and "Maximum Concurrent Executables" was -1 (which for some reason defaults to 3 concurrent processes even on our dual CPU server) - so after chanign that value to 4 - tada - all 4 files in parallel
I found 2 different versions about the behavior of SSIS when the default value of MaxConcurrentExecutables property is used.
If you look at BOL (http://msdn2.microsoft.com/en-us/library/ms137749.aspx) it says :"The number of executable files that the package can run concurrently. The default value of this property is -1, which indicates that there is no limit."
But if you look at 'Integration Services: Performance Tuning Techniques' white paper (http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx); it says "By default, this is set to -1, which translates to the number of logical machine processors plus 2. "
However, any of these 2 descriptions seems to be consistent with what you are describing. I belive the second version is closer to the true; but It would be interesting to get a confirmation of that.
Rafael Salas
