Thank you everybody for the input/assistance. I made the changes to the Parent pipeline to use the $Path. I was not sure how to pass the $Path field directly to the child without Parameters or run the Child without the Pipe Execute snap. With this process I am setting up, I can have anywhere from 1 to 15 files a day go into the directory.
I then modified the Child pipeline by removing the Mapper and then using the Parameter of _FileName in the reader.
With this new configuration, I am finally able to get a successful validation. However, the File Reader snap is always red on validation. Is this normal? In the Child Pipeline screen shot you can see this is Red.
I am able to run the pipelines and the data is being loaded successful based on record counts in the target table.
Parent Pipeline with Changes
![]()
Child Pipeline
![]()
Child Pipeline with Parameter
![]()