How can we automize the process of Excel to CSV/TXT conversion, prior to ETL/DataStage process. (with no human intervension)
I appreciate your help.
Thanks
Automize the process of Excel to csv/txt conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Automize the process of Excel to csv/txt conversion
You will need human intervention, at least in the design phase. The designer will need to create a script - it may be a small VBA script, it may be an Excel macro, it may be a BAT file.satish_valavala wrote:How can we automize the process of Excel to CSV/TXT conversion, prior to ETL/DataStage process. (with no human intervension)
I appreciate your help.
Thanks
Whatever it is, it can be invoked from DataStage, perhaps in an Execute Command activity in a job sequence, perhaps in a before-job subroutine. Since DataStage server is on UNIX, some form of remote execution request, such as rsh or rlogin, will be necessary. This may need some tweaking of Windows security mechanisms on the machine where the Excel files are.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.