Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Import complex-structured files


Hello,
I've got big files (10Mo) that have a special structure, with several parts.

Example :

#>PART_A
123|AAA|ZZZ|9887
24|DESHGG|SREFS|141
9851|Z|ZZZ|775
123|AAA||22214

>#

#>PART_B
DSF|ZREFS|65432
QQSDA|AAA|315

>#

I'd like to import these files into several tables (for example
TABLE_PART_A, TABLE_PART_B, ...)

I've tried to import the file in a main Table, and the to use a .NET split
function (and PIVOT operator, ...), but I'm going crazy with performance
issues.

Could someone help me with a better solution?

Thanks.
JN.

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc