A one-off shot at using, SSIS, I appear to be missing something.
From what I have read here, the Foreach Loop Container in which a File System Task has been placed is how one copies files contained in a source server folder to a folder on a target server. I have defined Source and Destination pkg variables using
UNC \\servername\aharedfolder and a FileName variable that is empty. My impression is that this is suppose to iterate through and copies all files in the source folder to the target. I only get
the first file copied.
In the FLC Collection section I am using the Foreach File Enumerator under which I have the Folder as
\\servername\sharedfolder and files as *.* . I am not using Expressions. The Variables Mapping reference my FileName variable.
In the FST, I both path variables set to True and reference the destination and source variables described above. Operation is Copy File.
I appears that I need to pass a list of the source folder file names to the FileName variable, rather than some built-in logic grabbing a files in the source folder. Is a passed filename list what I am missing?
View Complete Post