I am trying to find the best way to gather engineering drawings (files) from various places on a network share and copy them to another location on a different network share. I'd like to do this based on parameters within a SQL Server database. What would be the best way to do that?
For example: I'd like to build widget 123ABC. In order to do that I need engineering drawings for parts:
A - Drawings for part A are in location x
B - Drawings for part A are in location y
C - Drawings for part A are in location z
Copy all of those drawings and place them in location Share:\jobs123ABC
