I'm coming to the Community with another obstacle I'm facing at the moment. I have a data flow which will output several files (pipe delimited TXT files). The name of the files is dynamic, but I can pick it up on import (which I do) so when I output I can use the correct file name. The problem is that using this method the FileName and File columns are part of the output. This results in a structural validation error in the service I'm using to later insert the data.
- Capture the file name (column "File" in below screen capture of data viewer) so I can use it later on output to properly name my output file.
- Not include the "FileName" and "File" columns in final output of TXT file so it will pass structural validations later.
Any suggestions or ideas on a possible solution are greatly appreciated. Stay safe!
Please sign in to leave a comment.