General information
Title:
Transformation:merge allmost identical rows for output table
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.
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only