Roger

Roger

  • NA
  • 5
  • 0

Adding formatting to row delimited email files

Apr 7 2009 11:11 AM

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?


Answers (5)