DSXchange

Don't use the FTP stage which is metadata driven. Script an ftp session that goes an "mget" with the appropriate wildcard pattern. Talk to scripting gurus at your site, ftp scripts can be a little tricky to get right - typically someone there has already done something similar so this saves reinventing the wheel.

Thanks Chulett for quick response.

This process we are implementing first time, so no scripts are existing.
Right now we are working on Windows so need to find a way to ftp XML files to datastage server from remote server.
Once all the XML files are on Local server then I think need to use XML input stage to pick files based on file pattern and load to a database.

Please advice.

Thanks
Ravi

I would google for something like "Windows ftp script", you should be able to find plenty of examples and help out there.