Hi,
My Datastage Server is Installed in Unix. In our SQL Server we have stored procedure which extracts data and places into the file system. But unfortunately it can only place into SQL Server which is in NT Server. I want that file to be placed directly into the Unix File system. Which is the best way of doing this. If anyone has done this before. Will NFS help me to sort this problem. Need your feedback urgently.
Thanks
Kamal
NFS File SYSTEM
Moderators: chulett, rschirm, roy
-
vmcburney
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You can use DataStage to FTP the files from the NT server onto the Unix server. Just write a Unix script which ftps the files and call this from a DataStage sequence or batch job or use the FTP file stage.
If you want to place the data directly onto the Unix system you could consider connecting to the SQL Server database via DataStage and using it to extract the data rather than a procedure.
Vincent McBurney
Data Integration Services
www.intramatix.com
If you want to place the data directly onto the Unix system you could consider connecting to the SQL Server database via DataStage and using it to extract the data rather than a procedure.
Vincent McBurney
Data Integration Services
www.intramatix.com