SSIS: Way to handle hot folder items in parallel?
- by Dr. Zim
We have eight Xeon (i7) cores and 16 gig of RAM on our SSIS box. We have about 200 image files we want to convert using a command line utility every day. Currently the process is using Adobe Photoshop and droplets (very manual, taking upwards of two hours a day)
Using SSIS hot folders, is there a way to execute up to eight conversions at once?
Is there any way to tell a process completed or execute code upon it's completion?