File Pattern for Sequential File Stage

Ed Purcell · Post by **Ed Purcell** » Mon Apr 02, 2007 6:12 pm

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?

DSguru2B · Post by **DSguru2B** » Mon Apr 02, 2007 6:43 pm

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.

kumar_s · Post by **kumar_s** » Mon Apr 02, 2007 6:48 pm

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

Ed Purcell · Post by **Ed Purcell** » Tue Apr 03, 2007 10:30 am

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

Ed

kumar_s · Post by **kumar_s** » Tue Apr 03, 2007 9:51 pm

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

Ed Purcell · Post by **Ed Purcell** » Wed Apr 04, 2007 6:08 pm

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?

chulett · Post by **chulett** » Wed Apr 04, 2007 7:22 pm

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.

DSguru2B · Post by **DSguru2B** » Thu Apr 05, 2007 9:56 am

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