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

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.

Then in the copy task use the Path function


And let the job iterate through all lines.
Could take some time depeding on how many files you need to process.

This worked great. Thanks for the help!

What would need changed if the sproc has multiple columns output and for this particular task we only want the first column's data?

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: