TOPIC: export each row into a separate flat file

int i = 1;

public object DoWork()
{
	// get the TextFile Adapter from the WRITE side
	TextFileAdapter adapter = (TextFileAdapter)AdapterWrite;

	// Build the new filename	
	// first row  = new_flat_file_1.txt
	// second row = new_flat_file_2.txt
	// and so on
	// you can change the file name in the next line
	string filename = String.Format("new_flat_file_{0}.txt", i);

	i++; //increment the running number
	
	// set new file name on the WRITE side
	adapter.Filename = filename;

	// return the first input parameter for furher processing
	return InValues[0].GetValue();
}

@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files\FlowHeater\BIN\FHBatch.exe"

%FHBATCH% export-header.fhd
%FHBATCH% export-data.fhd

public object DoWork()
{
  // get the TextFile Adapter from the WRITE side
  TextFileAdapter adapter = (TextFileAdapter)AdapterWrite;

  // Build the new filename using the InvoiceNumber = first input parameter
  string filename = (string)InValues[0].GetString();
  if (filename == null)
    throw new Exception("not a valid invoice number!");
  
  filename += ".csv";  // you can changes the ending by yourself

  // set new file name on the WRITE side
  adapter.Filename = filename;

  // return the first input parameter = invoicenumber for furher processing
  return InValues[0].GetValue();
}

echo off
set FHBATCH="C:\Program Files\FlowHeater V2\BIN\FHBatch.exe"

%FHBATCH% export-invoice-header.fhd
%FHBATCH% export-invoice-data.fhd

%FHBATCH% export-invoiceitem-header.fhd
%FHBATCH% export-invoiceitem-data.fhd

REM ... and so on for more tables

public object DoWork()
{
  if (InValues.Length != 2)
    throw new Exception("2 Inputparameter expected!");

  // get the TextFile Adapter from the WRITE side
  TextFileAdapter adapter = (TextFileAdapter)AdapterWrite;

  // Build the new filename using the InvoiceNumber = second input parameter
  string filename = (string)InValues[1].GetString();
  if (filename == null)
    throw new Exception("not a valid invoice number!");
  
  filename += ".txt";  // you can changes the ending by yourself

  // set new file name on the WRITE side
  adapter.Filename = filename;

  // return the first input parameter for furher processing
  return InValues[0].GetValue();
}