|
Attached is a quick sample using subroutines, a Run Sql step and vbscript that loads data queried from Sql Server into a delimited macro. It also demonstrates how you can then use regular Visual Build Professional steps to do the actual work using this dynamic data.
While the design is fairly modular and generic you will probably need to modify it some for your particular situation/needs.
|