File System Task in SSIS

Wanting to use File System Task in SSIS to move files from

one location to another for archiving. I can't seem to figure out how to use a

wild card for the file name. It seems that I must specify the actual file name

which is a problem because only the first 4 letters in the file name remain a

constant.

Does anyone know how to use a wild card or a way to work

this in?

Darrin Turner wrote:

Wanting to use File System Task in SSIS to move files from one location to another for archiving. I can't seem to figure out how to use a wild card for the file name. It seems that I must specify the actual file name which is a problem because only the first 4 letters in the file name remain a constant.

Does anyone know how to use a wild card or a way to work this in?

Yes. use a ForEach loop to loop over the files (which you can specify with a wildcard) and then use the FileSystem task on each iterated file.

-Jamie

|||Ok, thank you. I will give that a try.