FTP Enterprise stage Error: read file from windows XP server

nsm · Post by **nsm** » Tue Dec 23, 2008 2:17 pm

I wanted to read file from Windows2000 server and write it into DB2.
My job design is like FTP Enterprise stage----->Transformer--->DB2/API stage.
Below are the errors I got .
I gave userid, Password and gave full path for URI.
>##E IIS-DSEE-TFOP-00020 15:13:43(006) <FTP_Enterprise_11> Error occurred during initializeFromArgs().
>##E IIS-DSEE-PFTP-00034 15:13:43(007) <FTP_Enterprise_11> uri : ftp://filepath/./../filename is not valid remote file.
##I IIS-DSEE-PFTP-00032 15:13:43(008) <FTP_Enterprise_11> uri : ftp://filepath/./../filename is having following ftp errors.
##I IIS-DSEE-PFTP-00033 15:13:43(009) <FTP_Enterprise_11> Not connected.
>##E IIS-DSEE-TCOS-00029 15:13:43(010) <main_program> Creation of a step finished with status = FAILED.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 23, 2008 6:59 pm

Not connected.

Hmm.

nsm · Post by **nsm** » Wed Dec 24, 2008 9:35 am

Ray,

I gave full file path for URI.

Under connection I mentioned:
ftp command :ftp
username: user id for windows server
pasword: password.

can you help me anything with details above..I am confused on why its not connectig?

nsm.

chulett · Post by **chulett** » Wed Dec 24, 2008 9:39 am

Post your "full path".

nsm · Post by **nsm** » Wed Dec 24, 2008 11:37 am

ftp://servername/folder1/Data transfer/Data load/New files/Files to Load/Filename.csv

chulett · Post by **chulett** » Wed Dec 24, 2008 11:44 am

Was wondering... just a pathname here, so remove the "ftp" and "server name" parts as the stage takes care of that for you. And you may have problems with the space in the pathname, perhaps try the "short name" for that portion.

nsm · Post by **nsm** » Mon Dec 29, 2008 12:23 pm

Chulett,

ftp://servername has to be part of URI path in version8.

I tried reading the file from path which has no spaces , didn't work.
Not sure what's happening.

Thanks
nsm.

chulett · Post by **chulett** » Mon Dec 29, 2008 12:34 pm

Me neither, don't have v8 to work with here.

kandyshandy · Post by **kandyshandy** » Mon Dec 29, 2008 1:22 pm

NSM, did you try FTP to that server from command prompt?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Dec 30, 2008 7:31 am

Did you try it outside ds?

nsm · Post by **nsm** » Tue Dec 30, 2008 12:12 pm

yes..Using PSFTP I can put the file on to Datastage server.

kandyshandy · Post by **kandyshandy** » Tue Dec 30, 2008 12:44 pm

PUT or GET? From your DataStage server, did you try FTP to server from where you need to GET the files?

nsm · Post by **nsm** » Tue Dec 30, 2008 2:39 pm

Kandyshandy,

Please read my question properly.

nsm.

kandyshandy · Post by **kandyshandy** » Tue Dec 30, 2008 2:46 pm

I understood like this. You want to get files from windows server to DS server and load the data to DB2. Am i right?

My question is
From your local machine, did you try doing FTP to windows server and GET the files? Was it successful?

chulett · Post by **chulett** » Tue Dec 30, 2008 3:16 pm

PSFTP is a form of secure FTP which is not what the stage uses, and which is why the suggestion is to let us know if plain old ftp works for you.