Transform Text To Text Using Bids

[Skittle]

I have a text file I want to reformat to an output text file. There are lots of ways I could do this but I'm curious to see how BIDS handles it

I have created a 'Flat File Source' and a 'Flat File Destination' and slapped a 'Data Conversion' in between the two so that I can map from one to the other.

I'm getting a wierd error message, 'Error: 0xC02020F0 at Data Flow Task, Flat File Destination [286]: No column was specified to allow the component to advance through the file.'

Can I transform a text file with just the three elements of a 'Flat File Source', 'Data Conversion' and 'Flat File destination'?


I suspect this is because I must use a 'Recordset Destination' to receive the input file rows and then process the recordset in a loop to output to the 'Flat File Destination'.




Dazed and confused