FTP transfers of XLS files

kennyapril · Post by **kennyapril** » Fri Sep 24, 2010 3:13 pm

Thank you

I received a automated message from the server which has the same port number along with the host name,userid,password

The remote server has SFTP service enabled on it,does FTP enterprise support server with SFTP service.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 24, 2010 3:15 pm

What exact version of DataStage are you running? (The answer may already be here on DSXchange - try a search for SFTP.)

kennyapril · Post by **kennyapril** » Fri Sep 24, 2010 3:28 pm

I am using 8.0.1,searching tells 8.1 has the feature but not 8.0.1

If this doesnot support SFTP then the server has to be enabled as FTP instead of SFTP.

Is this the solution or any other solution please let me know

ray.wurlod · Post by **ray.wurlod** » Fri Sep 24, 2010 7:10 pm

That's the only capability of the FTP stage (which is why I asked about the exact version). It may be that "they" will not allow ordinary FTP due to security requirements. In that case, construct a script (invoked from a job sequence) that performs a secure FTP to a local file on the server and use a Sequential File stage in a DataStage job on the server to read that file.

kennyapril · Post by **kennyapril** » Mon Sep 27, 2010 8:48 am

thanks ray
Got a solution

The admin gave me another hostname for the same server which is FTP so now I can read everything and write it to a file but the problem is the FTP stage has no option which says first line is column name true/false.

Now the column name is also read as a row,please suggest me any change to get rid of the column name issue.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 27, 2010 5:08 pm

Process every field as VarChar, then use a Sample or Transformer stage downstream of the FTP stage to skip the first row. Reparse your data after that (or in the Transformer stage) as required.

kennyapril · Post by **kennyapril** » Wed Sep 29, 2010 8:19 am

Now my job is in this way

FTP------------->transformer--------------->sequential file

I used the option first line is column name as true but still I get the column names in the records.

How can I skip the first row in a transformer?

please suggest me

ray.wurlod · Post by **ray.wurlod** » Wed Sep 29, 2010 5:09 pm

If the Transformer stage is running in sequential mode, then the constraint @INROWNUM > 1 will do it for you.

kennyapril · Post by **kennyapril** » Thu Sep 30, 2010 10:31 am

Great!!

That worked, Thanks Ray