I am having difficulty writing to a fixed length flat file.
I need to read records from an AS400 physical file then write them to a flat file on a windows 2000 server. I can read the file from the AS400 using execsql but am not sure how to write the records to the fixed length flat file, I have created a flat file schema to be used in the flow. I have tried using convertToString service but am getting no data in the “string” output of this service even though data is going in to the service. I have also created a simple service that maps two fields in to convertToString but again no output from service, the errorArray contains null.
Any help/quidence greatly appreciated