FTP xml files
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
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