DSXchange

Hi,

I need a help regarding a requirement... I need to design a job where I have Three files which will arrive in a folder..I need to create a simple job which will read all the three files one by One...and load datainto final table...but each column should be flaged with the file name from which it has fetched... Ex. Say 1st record came from File called "A" then it should be flaged as" A" in one of the flag column....

How can i achieve this....as my all three files can arrive at same time or may be at different time also

Use a job sequence to obtain list of files from the folder and call your load job with the file name as a parameter.

Give it a try and post if you have any issues.

The Sequential File stage supports a 'Filename' column it can add for you. Do you need to wait for all three before you process? How are you planning on doing that?

Yes - we know you "Need Help", that's why people start posts here. Let me see if I can help... [scratches head] hmmm...