FTP STAGE

[khanparwaz]

Hi ,
I AM Using Ftp stage in my job & files at remote server are ~ Delimited
while doing ftp to some other Ftp area or into some sequential file
its adding extra data in the last & First Row.

like this--
Header~abc~110~exl
insert~gth~456~36~784~tyi~rxz~1388.00
Trailor~rty~345~tre
Above is the actual format of file now after Ftp my file looks like as below -

Header~abc~110~exl~0~0~0~0
insert~gth~456~36~784~tyi~rxz~1388.00
Trailor~rty~345~tre~784~tyi~rxz~1388.00

In actual its copying the row above for missing columns
can any one give me solution on this, one thing i can not change the file
format.

[chulett]

Welcome! :D

The FTP stage is kind of a pain to use because it is metadata driven, unlike any other ftp. So you will have 'issues' like this using it for a file where the metadata changes from row to row.

Try defining the record as a single varchar field, telling it there are no delimiters and probably no quote characters as well. Sometimes that allows the record to be read in or written out unchanged in spite of the differences in the metadata.

That or fall back on a scripted call to command line ftp.

[khanparwaz]

Thanks Its working Fine now

[ketfos]

Hi,
Just wanted to cehck you you fixed the ftp problem.

Thanks
Ketfos

[khanparwaz]

Hi

its a bug with FTP I suppose but My purpose is Solved i just wanted to make a same copy to other location that i am getting just by defining
all the data into one big length varchar column.

but if You want to take data from delimited columns its still a bug
its adding records.
if you have any solution on this pls let me know.
Thanks in Advance

PK