in code-bugfixing/etl-processing/C#/VisualStudio/etlprocessing/CsvEtlCommand.cs [12:30]
public void Execute()
{
using (var reader = new StreamReader(sourceFile))
using (var writer = new StreamWriter(targetFile))
{
// Extract
string line = reader.ReadLine();
// Transform and Load
while (line != null)
{
string[] columns = line.Split(',');
var transformedLine = Transform(columns);
writer.WriteLine(transformedLine);
line = reader.ReadLine();
}
}
}