DSXchange

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?

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.

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

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.

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!