How to write the data in Text file

Rajendra_89 · Post by **Rajendra_89** » Sat Jul 13, 2013 7:32 am

Hi All,

I am new to the DataStage Tool

I am creating one job which takes the input data from the Sql server table,
Transforms it and put the data in flat file
I have created the job of the three stages Source, Transformer and Finally Sequential Stage to write the data in text file

But Sequential Stage is not allowing me to give the path of the Text file stored on my local machine
Can you please help in understanding what step I am missing here?

Thanks in Advance!

chulett · Post by **chulett** » Sat Jul 13, 2013 7:37 am

Everything runs on and all work is local to the ETL server, so things like files must be there to be read and will be written there. The 'workaround' is the use of an NFS mount (or Samba and the like) so that external systems appear local to the ETL server.

Rajendra_89 · Post by **Rajendra_89** » Sat Jul 13, 2013 7:44 am

Thanks Chulett

Do you have any links which will help me in setting up NFS on the Windows server 2003 machine?

chulett · Post by **chulett** » Sat Jul 13, 2013 7:52 am

I don't but I'm sure you can google something up rather easily. I'm not sure off the top of my head that you can do all of this from 'your end'... I'd imagine your company / SysAdmin would need to set this up on their end or at least be involved in the process. [shrug]

Rajendra_89 · Post by **Rajendra_89** » Sat Jul 13, 2013 8:15 am

ok.. Chulett I will follow up with my IT team now ...