I need to transform Foxpro table to SQL Server table with merging all rows into one where all column values are the same except one . For this the only column with the different values , I want them also to be merged as coma or space delimited string. Surely, I may produce Foxpro script in 5 minutes which wil do that and be a pre-processor action before ADO.Net phase starts, but let's assume I am not familiar with Visual Foxpro.

It doesn't seem to be problem to unify conversion of many Fox tables to SQL Server with some simple mapping as generic C# program or SSIS packages, but what possible approaches could be when anything like that is required.

What I may think of ( without thinking much about performance and memory constraints )

1. DataReader for input and Dictionary . Populate Dictionary with merging, then dump Dictionary to output table
2. Stored procedure as post-processing after transforming all rows which does that cleaning.

Anything else ? Ideally, I'd like to avoid mixing stored procedures for transformation with C# classes.