Page 1 of 1

Using FTP stage without file structure

Posted: Mon Jan 14, 2013 11:29 am
by hsahay
Hi guys

Wondering if there is a way to FTP files, using FTP stages, without knowing anything about their internal structure ?

Posted: Mon Jan 14, 2013 11:39 am
by ArndW
Not really, but you could fake it by using just one column per row (if the file has CR/LF) or by using a dummy column with fixed length and accepting an error on the last row.

Posted: Mon Jan 14, 2013 12:40 pm
by hsahay
Thanks ArndW.

But one would still need to know the record length for all the different files that may come in via FTP.

I guess i will have to look at a non datastage solution.