Copy files from multiple locations based on sproc output - VisualCron - Forum

Community forum

ngourley
2018-10-15T20:01:58Z
Hi,

Trying to figure out the best way to go about creating a job that would copy multiple files from different locations based on a stored procedure that produces the filepath for each file.

Any help would be appreciated.

Thanks,

Nick
thordw
2018-10-16T07:37:24Z
Hi
I would do the following, since you get a list with path + file

Task #1 Executes you're stored procedure
Task #2 Copy files task

Attach a loop to the copy task that uses previous output.
example.png
Then in the copy task use the Path function
example2.PNG

And let the job iterate through all lines.
Could take some time depeding on how many files you need to process.
ngourley
2018-10-18T15:34:53Z
This worked great. Thanks for the help!
ngourley
2018-10-29T21:04:00Z
What would need changed if the sproc has multiple columns output and for this particular task we only want the first column's data?
thomas
2018-10-30T06:08:27Z
If you only want one column, you can specify the column in the loop. If you want to access multiple column, use one of these functiions:

Capture.PNG
Scroll to Top