Roger
Absolute newbie, I am told this is one of the better C# forums. I have been asked to analyze 800K poorly formatted email files in MS SQL. I think the best way to import them into the database is using something like this http://msdn.microsoft.com/de-de/library/ms345160.aspx, using case statements and the multiple flat files connection manager. To do so I need to format the files by inserting something I can use for the case statement like Row1, Row2, Row3… Is there an efficient way to do this using C#, should I be posting on an SSIS forum? Any thoughts?