FTP transfers of XLS files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 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.
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.
Regards,
Kenny
Kenny
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am