Use File System Task in a For All dataflow.

[Peager]

Hair pulling time....

I have an SQL task that returns a list of 'From' and 'To' full file path specifications that I want to use to move some files.

1) I was able to set up an SQL Task that executes a stored procedure returning a list of files to move (with full paths) This data was mapped to an ADO result set variable.

2) I added a For Each Loop task on an ADO enumerator on the result set variable defined in step one. I mapped the columns from the ADO result set into 'From' and 'To' USER variables. Up to this point the package works.... just doesn't do much.

3) Within the For Each Loop task I added a File System Task configured to 'move file'. I am having trouble configuring the 'Source' and 'Destination'. I set the 'Source' and 'Destination' to the @[USER::From] and @[USER:To] in the Expressions section of the task configuration dialog. It all appears to be configured properly but I keep getting the dredded red X. "SourcePath" is not a valid operation "MoveFile".

Can someone set me right on this?

Thanks,

paul

 

[Peager]

I found the problem here.... I needed to initialize the From and To variables to viable file names.... did that ans it took off like a scared rabbit.