DSXchange

Hi,

I have not worked much with the FTP stage and need some help with it. I am using the above stage to tranfer a file to some required server. I am just using one column here called 'Data' which is a Varchar field of lenght 1000. Now in another job i am using the very same file to load a SQL table. The problem is how do i view this file which has abt 10 columns. I think it could have something to do with the format of this file.
Does anyone have any solution for this. Any help would be greately appreciated. Thanks in advance.

Ashish

A sequential file is just a long sequential list of bytes; the concept of "columns", "rows" and lines are no physical separations to the data just special characters that let programs interpret the ordering of the data.
In your case you are sending the file using FTP as logical blocks of 1,000 characters and most likely have told the FTP that there are no column delimiters.

In your program where you want to split this data into 10 columns you will need to either specify a delimiter character if you have one or use fixed length blocks (i.e. 10 columns at 100char apiece).

Do you know the format of the file?