I will have one and possibly many fixed length flat files that I need to combine together into only 1 input source file before I run my transfer. They will all be in the same directory and all the file names will start with OneCodeAcs?.txt with the ? being anything. I also need to move/rename the files after processing so that the directory only contains the current days files that need to be processed.
3 comments
-
Support I would recommend using a combination of workflow and dataflow. In the workflow, drag-n-drop a FileSystemEntriesSource. Then, connect that to a dataflow or another workflow. Open the properties for the subsequent job, and replace the filepath for the source of that job with the iterrated filepath from the FileSystemEntriesSource (e.g. $FileSystem1.FullPath). So, it would look like :
FileSystem1----->RunDataflow1.
This will cause RunDataflow1 to run as many times as there are files in the directory. If you need to do additional processing, replace RunDataflow1, with a workflow.
-
phcaptjim Can you post an example of this? I know it sounds simple enough but I'm brand new to Centerprise and this is exactly the kind of task I'm hoping to accomplish. Thanks!
-
Rick Chang Are there other options beside using a WORKFLOW if we only have the PROFESSIONAL edition?