Which one can be good in terms of performance...

See more:

SSIS

SQL-Server-2008R2

Hello everyone,

I have to process file with data which contains more than 11 lacs (Million) rows.

Problem, Each row have data which I need to split and each row will make up 5 rows to Insert or update. Looking at performance point, Which one is suggestable:

1. Writing CTE to split each row into 5 and then CTE Result use merge statement.
2. Create table and dump entire data, Run logic/stored procedure which will generate 5 rows from each row into another table... and then use it with merge..

3. Create temp table and split data. Use that temp table in merge statement.

Any better idea than this.

Please note I am using SSIS to read file as we have multiple files....

Thanks,