DSXchange

If I specify a File Pattern for the source on the output tab of a sequential file stage (and pull in data from multiple files) is there any way to know the name of the file that is coming in as each record is read in?

Yes, there is. There is a property for that, cannot remember it off of my head, but there is. I think its called File Name or something. Shortly someone will come along with specifics. Or I can check tomorrow and let you know.

DSguru2B was referring to "File Name Column" option. You ll get the corresponding file name for each row.

Thanks, I see it now. "File Name Column" is an option on the sequential file stage.

Ed

If that answers the question, you can mark the post as resolved.

Whoops!

When I specify a file pattern for the output source and then enter something like ABC* for the file pattern, the sequential stage reads in the multiple files just fine, but the File Name Column reports the file name as ABC*. I was hoping that it would give it as ABCRestOfFileName. Any suggestions?

I know that issue has been discussed before, don't recall the resolution. Search the forums for 'file name column' and see what turns up.

More specifically, Craig's last reply in this post.