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.