File System Task with Multiple Inputs does not execute

[PeetS]

I am using a ForEach loop to process text files into different tables. I use a script task to direct the processing to different data flows (depending on the file name) After the data flow is completed, I use a File System task to move the file to another location. I want to use the same File System task to move the files regardless of which data flow did the processing. The problem that I have is that if I connect all the data flows to the same File System task, it just does nothing. If I duplicate the File System task and connect each data flow to its "own" file system task, it works perfectly. I have tried to use a script task to move the files, but with the same result. It seems like a waste to have to duplicate the task in order to get the job done. Any ideas? Thanks.PeetS

 

[Catadmin]

Try setting up the file names within a SQL Server table and have the FileSystem Task get its input from the table?

BTW, that's a WAG.

Are all your files, regardless of name, going to the same UNC path?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"