SSIS: Way to handle hot folder items in parallel?

Posted by Dr. Zim on Stack Overflow See other posts from Stack Overflow or by Dr. Zim
Published on 2010-04-26T16:22:27Z Indexed on 2010/05/01 16:47 UTC
Read the original article Hit count: 197

Filed under:
|

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?

© Stack Overflow or respective owner

Related posts about ssis

Related posts about automation