Need to read a CSV file from remote server by using FTP stag

sagar deshmukh · Post by **sagar deshmukh** » Fri Dec 12, 2008 5:54 am

Hi i have a CSV file as below
' '90028' 10: ADULT BB1' '12/08/2008' 10:54:02' '0000062744001' '0.95' '1'
' '90028' '10: ADULT BB1' '12/08/2008' 10:54:02' '0000062744002' '0.95' '1'
'' '90028' '10: ADULT BB1' 12/08/2008'

I need to read it from remore server. please let me know what setting i need to do, or any special stage i need to use?

chulett · Post by **chulett** » Fri Dec 12, 2008 7:43 am

Create your metadata like normal as if you were going to be reading it from a Sequential File stage and then load that metadata into the FTP stage. That or script a solution using command line FTP to get the file local to your DataStage server.

sagar deshmukh · Post by **sagar deshmukh** » Fri Dec 12, 2008 7:50 am

can you please mail me the sulution to sagarddd@gmail.com please.

chulett · Post by **chulett** » Fri Dec 12, 2008 7:54 am

No. What exactly would I mail you?

Get a local copy of the file, make sure you can read it and then adding the FTP part should be fairly easy.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 12, 2008 12:17 pm

sagar deshmukh wrote:can you please mail me the sulution to sagarddd@gmail.com please.

We don't do that, except sometimes in exchange for money, and particularly not to non-work email addresses. You might be a spy from the "dark side" for all we know!